/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

2 votes273 views1 answer
Max of matrix numpy
Python
0 vote260 views2 answers
Cannot create group in read-only mode. keras
Python
0 vote223 views1 answer
Neo4j python
Python
0 vote274 views1 answer
Pandas most and least occurrence value
Python
0 vote283 views1 answer
Run for loop inside pdb
Python
-1 vote285 views1 answer
Convert .tif images files to .jpeg in python
Python
0 vote261 views2 answers
Django get all models
Python
1 vote282 views5 answers
Embed python discord
Python
2 votes349 views2 answers
Django queryset is in list
Python Django
22 votes335 views3 answers
How to get tomorrow date in python
Python