/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

1 vote172 views1 answer
Create alinked list inb pyhton
Python
5 votes183 views4 answers
Open mat file in python
Python
1 vote196 views1 answer
Scrapy get inside attribute value
Python
3 votes188 views3 answers
String list to list
Python
0 vote187 views1 answer
Deduplication jaccard python
Python
2 votes180 views2 answers
How to rotate the list in python
Python
0 vote183 views1 answer
Start virtualenv with python version
Python
3 votes248 views2 answers
Read specific columns from csv in python pandas
Python
0 vote275 views1 answer
Python Write code that asks users to enter the year they were born. Print out how many years old they will turn in 2019.
Python
0 vote158 views3 answers
How to transpose a matrix in python
Python