/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

10 votes315 views6 answers
Range function in python
Python
1 vote307 views1 answer
Sort and remove duplicates list python
Python
3 votes302 views1 answer
Sort a list by values of another one python
Python
22 votes346 views5 answers
How to check if a word is a palindrome in python
Python
14 votes348 views1 answer
Average value of list elements in python
Python
68 votes294 views6 answers
Python list files in directory
Python
1 vote335 views2 answers
Countplot in pandas
Python
0 vote325 views1 answer
Numpy mask without losing shape
Python
0 vote384 views1 answer
Django python base 64 decode
Python Django
24 votes445 views3 answers
Flask vs django
Python Flask