/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

5 votes89 views2 answers
Python calc days between dates
Python
1 vote112 views1 answer
Python fme logger
Python
10 votes107 views3 answers
Pacman 30th anniversary
Python
0 vote110 views1 answer
*args **kwargs together in python
Python
0 vote115 views1 answer
Creating fake instagram accounts with python
Python
69 votes100 views6 answers
Python shuffle array
Python
4 votes130 views1 answer
Django pandas queryset
Python Django
4 votes99 views2 answers
How to determine python project parent dir
Python
5 votes99 views3 answers
Series change index pandas
Python
0 vote99 views1 answer
How to check if variable in python is of what kind
Python