/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

-1 vote229 views2 answers
Scaling
Python
0 vote179 views2 answers
Python play mp3 in background
Python
0 vote185 views1 answer
Matplotlib don't use the alpha value of the plot in legend
Python
0 vote191 views1 answer
Pandas make new dataframe
Python
0 vote185 views1 answer
How to display percentage in pandas crosstab
Python
3 votes186 views2 answers
Adjust tick label size matplotlib
Python
1 vote197 views2 answers
Django in conda
Python
0 vote180 views1 answer
Gwt height with tkinker
Python
5 votes202 views6 answers
Python dictionary comprehension
Python
10 votes189 views3 answers
String to hex python
Python