Why parsing an Excel file gives incorrect Sheet names?

Question

Python

I need to parse an xlsx file. The file contains a sheet called '1A'. However, when I use . I called and noticed that the font of the A in the dictionary key is different from all the A 's elsewhere. How can this be fixed? pd.read_excel(file, sheet_name='1A')XLRDError: No sheet named <'1A'>pd.read_excel(file, sheet_name=None)

Answer 1

probably the name of the sheet in the international layout, and not in Ansi - you can fix it by opening the Excel and renaming the sheet.