/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 vote117 views1 answer
Pytorch squeeze
Python
4 votes94 views2 answers
Python print time
Python
2 votes102 views2 answers
Convert pdf to csv python
Python
42 votes111 views6 answers
Pickle dump
Python
0 vote106 views1 answer
Seaborn heatmap text labels
Python
0 vote107 views2 answers
Insert character into string at position x python
Python
0 vote105 views1 answer
Django add queury parameters to reverse
Python
0 vote98 views1 answer
If keyboard.is_pressed
Python
31 votes98 views6 answers
Count unique pandas
Python
0 vote100 views1 answer
Numpy expand_dims
Python