/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

20 votes303 views1 answer
ParserError: Error tokenizing data. C error: Expected 1 fields in line 87, saw 2
Python
0 vote317 views1 answer
Remove toggle/pandaslux
Python
1 vote301 views1 answer
Numpy slice array into chunks
Python
0 vote320 views1 answer
Opencv set window size
Python
2 votes368 views1 answer
Django get current date
Python Django
3 votes319 views2 answers
How to print anything in python
Python
0 vote331 views1 answer
Get source selenium python
Python
0 vote306 views1 answer
Python mysqlclient not installing
Python
1 vote343 views1 answer
Python for loop even numbers
Python
4 votes354 views1 answer
Python 3.7 download for windows 7 32-bit
Python