/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

0 vote129 views1 answer
AttributeError: type object 'User' has no attribute 'query'
Python
6 votes131 views2 answers
Python check if folder is empty
Python
13 votes126 views3 answers
Pandas set a value in colmns as the maximum value
Python
0 vote143 views1 answer
How to read panda column
Python
0 vote121 views1 answer
Python return min length of list
Python
1 vote178 views1 answer
Django return only part of string
Python Django
2 votes122 views1 answer
Discard vs remove python
Python
1 vote134 views1 answer
Pandas forward fill after upsampling
Python
3 votes152 views2 answers
Unix to date python
Python
1 vote123 views1 answer
Django sites framework
Python