/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 vote143 views1 answer
Set text and background color in pandas table
Python
2 votes137 views1 answer
Python recursive function return none
Python
0 vote140 views1 answer
Tags['tag'].value_counts()
Python
6 votes134 views2 answers
Change tkinter window name
Python
0 vote131 views1 answer
Pyplot histogram labels in center
Python
7 votes136 views2 answers
How to add a image in tkinter
Python
36 votes167 views3 answers
Python image library
Python
2 votes147 views2 answers
Python code fpr fibon
Python
0 vote136 views1 answer
Ipaddress in python
Python
15 votes143 views6 answers
Python last element of list
Python