Trying to import an excel into the database using python xlrd package gives an error: XLRDError: Excel xlsx file; not supported

Asked Mar 10 '22 at 13:59

Active Mar 10 '22 at 21:32

Viewed 124 times

I tried to open the excel using the code given below:

loc="/Users/shruti/Downloads/user.xlsx"
wb=xlrd.open_workbook(loc)

I get the following error.

XLRDError: Excel xlsx file; not supported

How do I resolve it?

edited Mar 10 '22 at 21:32

pppery

asked Mar 10 '22 at 13:59

user18419235

[xlrd](https://pypi.org/project/xlrd/) is a library for reading data and formatting information from Excel files in the historical **.xls** format. use other libs such as *openpyxl* – Lei Yang Mar 10 '22 at 14:00
2

Possible duplicate of [xlrd.biffh.XLRDError: Excel xlsx file; not supported](https://stackoverflow.com/questions/65254535/xlrd-biffh-xlrderror-excel-xlsx-file-not-supported) – pppery Mar 10 '22 at 21:31

0 Answers0