Is there a different way to read .xls and .xlsx file in Python using Pandas?

Asked Nov 07 '22 at 20:19

Active Nov 07 '22 at 20:19

Viewed 141 times

Is there a different way to read .xls and .xlsx file? I am currently using read_excel method but it doesn't work with .xlsx file.

df = pd.read_excel(r'path/sample.xlsx',skiprows=2)

It doesn't work with .xlsx file and it gives the below error.

Error: xlrd.biffh.XLRDError: Excel xlsx file; not supported

asked Nov 07 '22 at 20:19

MPasks

1

Does this answer your question? [Pandas cannot open an Excel (.xlsx) file](https://stackoverflow.com/questions/65250207/pandas-cannot-open-an-excel-xlsx-file) – BigBen Nov 07 '22 at 20:19
I appreciate that link just for the extra saucy first answer. :D – Vincent Rupp Nov 07 '22 at 20:51
the link helped. Thanks. – MPasks Nov 08 '22 at 16:33

0 Answers0