/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 vote178 views1 answer
Change order of barh matplotlib
Python
0 vote177 views1 answer
Access Google Photo API with Python using google-api-python-client
Python
4 votes159 views1 answer
Python pygame screen example
Python
15 votes166 views3 answers
Python - gropuby based on 2 variabels
Python
1 vote163 views1 answer
Palindrome rearranging python
Python
37 votes187 views6 answers
Pyplot.plot
Python
0 vote115 views1 answer
56
Python
1 vote161 views1 answer
How to custom page not found in django
Python
0 vote195 views1 answer
Calculate mape python
Python
0 vote175 views1 answer
How to change speed in ursina
Python