Error when reading excel in Python: unsupported format or corrupt file?

Question

It is normal to open it with excel, but it cannot be read in Python. Tried read_excel and xlrd.open_workbook

Answer 1

Try pandas reading, pay attention to the encoding format