/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

17 votes233 views4 answers
Python delete value from dictionary
Python
46 votes242 views6 answers
Round to two decimal places python
Python
0 vote234 views1 answer
Why tensorflow not working in .py file
Python
1 vote218 views1 answer
Write a function to split a string and convert it into an array of words.
Python
2 votes253 views4 answers
How to add column to np array
Python
-2 votes261 views2 answers
Python program to find n prime numbers
Python
0 vote192 views0 answer
Python
5 votes237 views3 answers
Get image from url python
Python
33 votes249 views6 answers
Merge dataframe
Python
40 votes268 views6 answers
Pandas replace null with 0
Python