Here is what I got from an Excel sheet name, there are some unexpected special characteristics. So I designed a simple method to resolve them.

Figure 1

First, we obtained the list of sheet name using the above method: xl = pd.ExcelFile(sFilename)

aSheet = xl.sheet_names

Then iterate the names and change the string: ss=openpyxl.load_workbook(sFilename) for sSheet in aSheet: sSheet_new = sSheet.replace(‘\xad’, ‘’) ss_sheet = ss[sSheet] ss_sheet.title = sSheet_new (The python indentation may have issue).

Some references: