/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 vote249 views1 answer
Python requirments.txt
Python
0 vote318 views1 answer
Django strptime
Python Django
0 vote267 views1 answer
Concatenate directories python
Python
0 vote328 views1 answer
Push to pypi
Python
0 vote328 views1 answer
Solution to Remove Recursion Limitation in python
Python
17 votes260 views4 answers
Python delete value from dictionary
Python
0 vote288 views1 answer
Como fazer um bot spamm no discord com python
Python
1 vote274 views1 answer
Elif in django template
Python
0 vote277 views1 answer
Sort rows by values dataframe
Python
9 votes294 views9 answers
Selection sort
Python