/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 vote171 views1 answer
ValueError: Invalid format specifier
Python
1 vote154 views1 answer
Python - Change List Items
Python
0 vote199 views1 answer
Ion Flux Relabeling
Python
0 vote195 views2 answers
Pandas replace non numeric values with 0?
Python
-1 vote172 views2 answers
Detect grayscale image in python opencv
Python
0 vote175 views1 answer
Google youtuve api
Python
8 votes172 views2 answers
List of single item repeated python
Python
0 vote197 views1 answer
In dataframe particular column to string
Python
0 vote170 views1 answer
Python list safely pop
Python
2 votes183 views2 answers
Can immigrants vote in uk
Python