/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

8 votes157 views4 answers
Normalize data python pandas
Python
1 vote142 views1 answer
How to seperate words and number in a list
Python
1 vote135 views2 answers
Django client ip
Python
14 votes147 views6 answers
Find last element in list python
Python
2 votes139 views1 answer
Add hour minutes second python
Python
5 votes135 views1 answer
Python close input timeout
Python
0 vote137 views1 answer
Numpy collapse last dimension
Python
0 vote149 views1 answer
Pythonpath manager spyder
Python
69 votes148 views6 answers
Python online compiler 3.8
Python
2 votes131 views1 answer
User input of int type in python
Python