/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 vote227 views3 answers
Dataframe row print
Python
1 vote229 views1 answer
How to make a bot say hello <username> when a user says hello in discord with python
Python
26 votes229 views2 answers
Import time in python
Python
9 votes206 views2 answers
Django import Q
Python
0 vote229 views1 answer
Discard method in python
Python
0 vote238 views1 answer
Pytorch torchaudio torchvision cu113
Python
1 vote248 views1 answer
ValueError: There may be at most 1 Subject headers in a message
Python
0 vote239 views1 answer
Restaurant management system in django
Python
1 vote206 views1 answer
Download images python google
Python
2 votes229 views1 answer
Change false to true python
Python