/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 vote134 views1 answer
Apply dictionary to df clumn
Python
1 vote137 views1 answer
Isnull().mean() python
Python
3 votes146 views2 answers
Taking multiple input in python
Python
0 vote156 views1 answer
Basic script
Python
0 vote143 views1 answer
No module named 'mpl_toolkits.basemap'
Python
1 vote134 views2 answers
What is fourier transform in python
Python
0 vote142 views1 answer
Isntall packages to databricks
Python
0 vote144 views1 answer
Get a list of ids from queryset django
Python
0 vote228 views2 answers
User logout in django rest framework
Python Django
0 vote146 views3 answers
Github/hacksofteare
Python