/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 vote198 views1 answer
Python obtenir nom des fichiers d'un dossier
Python
0 vote149 views1 answer
Are there learning activities for django-debug-toolbar
Python
1 vote205 views2 answers
Four digit representation python
Python
1 vote201 views1 answer
Db_index django
Python
0 vote208 views1 answer
Turn list of arrays into array
Python
0 vote200 views1 answer
Python - Cara Bermain Mp3 File
Python
0 vote200 views1 answer
Format when turning float into string
Python
0 vote192 views1 answer
Find All Occurrences of start indices of the substrings in a String in Python
Python
0 vote197 views1 answer
Python data structures 9.4
Python
-1 vote213 views1 answer
ValueError: cannot reshape array of size 98292 into shape (16382,1,28) site:stackoverflow.com
Python