/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 vote138 views1 answer
Flask No application found. Either work inside a view function or push an application context
Python
0 vote182 views1 answer
Django password field encryption
Python Django
3 votes139 views1 answer
Datetimes to day of year python
Python
0 vote159 views2 answers
Operator in django query
Python
0 vote150 views2 answers
How to Send WhatsApp API using python
Python
1 vote175 views1 answer
Django round 2 decimal
Python Django
4 votes150 views2 answers
Is python easy or hard to learn
Python
92 votes109 views3 answers
Python self
Python
0 vote159 views1 answer
Months of the year python list
Python
0 vote158 views2 answers
Python split word into letter pairs
Python