/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

72 votes266 views6 answers
Python compilers
Python
1 vote194 views1 answer
Como deixar todas as letras maiusculas no python
Python
0 vote229 views2 answers
Sqlalchemy function for default value for column
Python
0 vote231 views1 answer
Django queryset to form
Python Django
1 vote206 views10 answers
Recursion
Python
0 vote197 views1 answer
Reversing Ints
Python
5 votes201 views1 answer
Python how to skip iteration
Python
1 vote223 views2 answers
Python long
Python
0 vote204 views1 answer
Change each line color as a rainbow python
Python
1 vote252 views1 answer
Check if queryset is empty django template
Python Django