/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 vote279 views1 answer
Increment numper in python
Python
0 vote243 views1 answer
Jinja 2 iterate over dictionary
Python
1 vote262 views2 answers
Four digit representation python
Python
1 vote226 views1 answer
Numpy isinstance
Python
-1 vote234 views1 answer
How to convert one dimensional array into two dimensional array
Python
11 votes245 views4 answers
Add conda env to jupyter
Python
0 vote251 views1 answer
How to use rmse as loss function in keras
Python
0 vote234 views2 answers
Pytest using tempfile
Python
22 votes310 views3 answers
How to get tomorrow date in python
Python
1 vote279 views1 answer
How to add two different times in python
Python