/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 vote244 views1 answer
Mysql.connector.errors.InterfaceError: Failed executing the operation; Not all parameters were used in the SQL statement
Python
1 vote277 views1 answer
Django crispy forms foundation for site
Python
0 vote191 views1 answer
Python - notification messages
Python
12 votes217 views5 answers
Conda python update
Python
0 vote222 views10 answers
Python pygeoip example
Python
0 vote212 views1 answer
Funny application in python
Python
0 vote241 views1 answer
Matplotlib boxplot remove outliers
Python
2 votes213 views1 answer
Get local ipv4
Python
0 vote237 views1 answer
Qtablewidget clear python
Python
0 vote221 views1 answer
Function to sort a list of points based on their x and y-coordinates
Python