/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

12 votes159 views4 answers
Key pressed pygame
Python
1 vote151 views2 answers
Urllib.error.HTTPError: HTTP Error 404: Not Found
Python
0 vote151 views1 answer
Pytthon how many fridays´ between two dates
Python
1 vote150 views1 answer
Flask run app reset on change
Python
0 vote188 views1 answer
Rotch randn
Python
0 vote151 views1 answer
Networkx select edge
Python
-1 vote217 views2 answers
Django cleanup
Python Django
21 votes111 views5 answers
Tkinter window
Python
0 vote175 views1 answer
Pandas increment value on condition
Python
0 vote167 views1 answer
Pong code python
Python