/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 vote334 views2 answers
Style django forms with crisp
Python Django
0 vote360 views2 answers
Numpy softmax
Python
2 votes334 views2 answers
Python convert hex to binary
Python
3 votes343 views2 answers
Pandas - from umeric to string
Python
8 votes321 views3 answers
F.readlines python
Python
0 vote337 views1 answer
Microsoft python
Python
0 vote360 views1 answer
Python tkinter entry hide text
Python
2 votes325 views2 answers
How to take first digit of number python
Python
0 vote334 views1 answer
Filters rows using the given condition
Python
0 vote417 views1 answer
Using a generic exception block
Python