/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 vote282 views1 answer
ModuleNotFoundError: No module named 'nbformat'
Python
0 vote292 views1 answer
Python open all files of type csv
Python
0 vote258 views1 answer
Icon tkiner
Python
0 vote265 views1 answer
Matrix diagonal sum leetcode in java
Python
1 vote286 views1 answer
Skip header in csv python
Python
77 votes281 views6 answers
Random from list python
Python
0 vote273 views1 answer
What is self
Python
0 vote269 views1 answer
Timedelta days to year pandas
Python
38 votes276 views3 answers
Pil python install
Python
0 vote259 views1 answer
Get py version
Python