/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

4 votes280 views1 answer
Round python with list
Python
1 vote290 views1 answer
How to capture a single photo with webcam opencv
Python
0 vote303 views1 answer
Django.db.backends.mysql install
Python Django
1 vote291 views2 answers
Sep and end in print python
Python
0 vote287 views1 answer
Los mejores script de phython
Python
2 votes273 views1 answer
Python optionmenu tkinter
Python
0 vote273 views1 answer
Pandas check is field is null or empty
Python
-1 vote288 views1 answer
How to print the 3erd character of an input in python
Python
1 vote323 views1 answer
Print only small Latin letters a found in the given string.
Python
0 vote289 views1 answer
Flask new response style with `make_response`
Python