/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

0 vote295 views1 answer
How to use fastapi ApiClient with pytest
Python
13 votes384 views2 answers
Delete database entry using name django
Python Django
1 vote284 views1 answer
How to print list without for loop python
Python
0 vote292 views1 answer
List Comprehension generate a list
Python
0 vote301 views1 answer
How to round off values in columns in pandas in excel
Python
0 vote270 views2 answers
Python simple project
Python
0 vote327 views1 answer
AttributeError: 'NoneType' object has no attribute 'dropna'
Python
1 vote311 views1 answer
Drop row with condition dataframe
Python
10 votes314 views2 answers
Rotation turtle python
Python
20 votes335 views5 answers
Save list to file python
Python