/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

2 votes351 views2 answers
Python sort based on multiple keys
Python
8 votes392 views1 answer
Python CSV Has No Attribute 'Writer
Python
0 vote356 views1 answer
.replace pandas in for loop
Python
0 vote351 views1 answer
What is tensor in deep learning
Python
0 vote357 views1 answer
Python scipy moving average
Python
0 vote457 views2 answers
Spacy french stopwords
Python
-1 vote340 views1 answer
Rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrooom
Python
4 votes384 views3 answers
Pandas remove row if missing value in column
Python
0 vote358 views1 answer
"serializers" is not defined
Python
1 vote356 views1 answer
How many columns can a pandas dataframe have
Python