/Python/XLRDError: Excel xlsx file; not supported

XLRDError: Excel xlsx file; not supported

pandas.read_excel('cat.xlsx', engine='openpyxl')

Source: stackoverflow.com

Raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported') XLRDError: Excel xlsx file; not supported

pip install xlrd==1.2.0

Source: stackoverflow.com

Python pandas read_excel xlrderror excel xlsx file not supported

# Make sure pandas is upgraded and that openpyxl is installed then try again
pip install pandas --upgrade
pip install openpyxl

Xlrderror: excel xlsx file; not supported

As noted in the release email, linked to from the release tweet and noted in large orange warning that appears on the front page of the documentation, and less orange, but still present, in the readme on the repository and the release on pypi:

xlrd has explicitly removed support for anything other than xls files.

In your case, the solution is to:

make sure you are on a recent version of Pandas, at least 1.0.1, and preferably the latest release. 1.2 will make his even clearer.
install openpyxl: https://openpyxl.readthedocs.io/en/stable/
change your Pandas code to be:
df1 = pd.read_excel(
     os.path.join(APP_PATH, "Data", "aug_latest.xlsm"),
     engine='openpyxl',
)

Similar codes

4 votes320 views1 answer
Django slug int url mapping
Python
0 vote326 views1 answer
Python format decimal list
Python
12 votes287 views1 answer
Python regex cheat sheet
Python
0 vote322 views1 answer
Python reduce function to sum array
Python
1 vote332 views2 answers
Linspace python
Python
36 votes277 views5 answers
Python move file
Python
1 vote279 views1 answer
How to make an simple python client
Python
18 votes374 views5 answers
Python dictionary to json
Python
2 votes321 views1 answer
How to multiply inputs in python
Python
0 vote280 views1 answer
Python - subtracting dictionary values
Python