/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

14 votes122 views5 answers
Python while continue
Python
0 vote111 views1 answer
Code coverage pytest as html
Python
0 vote126 views1 answer
How to find xpath by contained text
Python
2 votes107 views1 answer
Why is python hard
Python
1 vote116 views2 answers
How to pair up two lists in python
Python
2 votes124 views3 answers
Rotate matrix 90 degrees clockwise python
Python
0 vote134 views2 answers
Split paragraphs in python
Python
3 votes113 views1 answer
Module 'cv2' has no 'videocapture' member python
Python
1 vote119 views2 answers
Python mp4 to mp3
Python
1 vote136 views1 answer
Select realted for foreign key table in django
Python Django