/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 vote144 views1 answer
How to put words into list
Python
35 votes153 views2 answers
Download pyaudio for python 3.9
Python
10 votes125 views3 answers
Package in python
Python
1 vote143 views2 answers
Valeur absolue python
Python
0 vote121 views1 answer
Getting vocab from a text file python
Python
0 vote127 views1 answer
Python how to make multiple box plots
Python
1 vote162 views1 answer
Iterate over every alternate character in string python
Python
42 votes125 views6 answers
Create requirements.txt python
Python
1 vote91 views1 answer
Plotly font size
Python
2 votes139 views1 answer
How to change button background color while clicked tkinter python
Python