/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

5 votes157 views2 answers
Copy a file from one directroy to other using python
Python
2 votes207 views1 answer
How to make a python program to count from 1 to 100
Python
0 vote160 views1 answer
Pytesseract restrict char
Python
1 vote177 views3 answers
Py random list integers
Python
-2 votes170 views1 answer
How to check if a string contains spaces in python
Python
0 vote170 views1 answer
Fransfer python project to pythonanywhere
Python
0 vote208 views1 answer
Last executed query in flask api
Python Flask
1 vote163 views1 answer
Hotel room allocation tool in python
Python
0 vote171 views1 answer
Ldap python how to print entries
Python
25 votes179 views2 answers
Python slit
Python