/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

25 votes169 views10 answers
Github
Python
103 votes210 views6 answers
Time.sleep() python
Python
0 vote182 views3 answers
1038 solution python
Python
-3 votes133 views2 answers
Detect text in image opencv
Python
12 votes171 views6 answers
How to Find Unique Values in a Column in Pandas
Python
0 vote201 views1 answer
Fichier python pour brython
Python
0 vote146 views3 answers
How to transpose a matrix in python
Python
-1 vote170 views1 answer
Use linear regression to predict python
Python
-1 vote124 views2 answers
Model deployment with flask
Python
5 votes174 views4 answers
Open mat file in python
Python