/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

14 votes183 views2 answers
Check dictionary is empty or not in python
Python
0 vote165 views1 answer
Default dictionary value
Python
1 vote177 views1 answer
How to sort by length python
Python
0 vote163 views1 answer
How can item in list change in int in python
Python
8 votes157 views2 answers
Numpy normal distribution
Python
1 vote157 views1 answer
Python pandas apply function to one column
Python
0 vote162 views1 answer
-2 in python
Python
0 vote148 views1 answer
Inherit init method
Python
1 vote166 views2 answers
Python long
Python
2 votes174 views1 answer
Pandas drop extension name from list of files
Python