python pandas read_excel xlrderror excel xlsx file not supported

Trained Tuna answered on April 16, 2021 Popularity 9/10 Helpfulness 10/10

related XLRDError: Excel xlsx file; not supported

related xlrderror: excel xlsx file; not supported

Comment

# Make sure pandas is upgraded and that openpyxl is installed then try again
pip install pandas --upgrade
pip install openpyxl

Popularity 9/10 Helpfulness 10/10 Language shell

Source: Grepper

Tags: excel file pandas python shell xlsx

Link to this answer
Share Copy Link

Contributed on Jul 30 2021

Trained Tuna

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

pandas.read_excel('cat.xlsx', engine='openpyxl')

Popularity 10/10 Helpfulness 10/10 Language python

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Apr 16 2021

Real Raccoon

0 Answers Avg Quality 2/10

Comment

XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'Sr. No.,'

Popularity 1/10 Helpfulness 1/10 Language python

Source: Grepper

Tags: excel python xlsx

Link to this answer
Share Copy Link

Contributed on Jun 27 2022

Neha Pole

0 Answers Avg Quality 2/10