/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 vote168 views1 answer
Python check equality of floats
Python
0 vote209 views1 answer
From flask import Flask app = Flask(__name__) @app.route('/',methods = ('GET')) def home(): return ('Hello World!!1') if __name__== '_main_': app.run()
Python Flask
87 votes164 views6 answers
Write dataframe to csv python
Python
2 votes169 views5 answers
Django documentation
Python
5 votes195 views10 answers
Online python to c converter
Python
0 vote167 views3 answers
Python datetime add month
Python
1 vote196 views1 answer
Create new column using dictionary padnas
Python
-2 votes175 views1 answer
Stats.norm.cdf(2,loc=mean, scale=std_dev)
Python
3 votes172 views2 answers
Tensorflow
Python
0 vote188 views2 answers
Python function overloading
Python