10 C
New York
Wednesday, January 10, 2024

Repair Error "xlrd.biffh.XLRDError: Excel xlsx file; not supported"


Python has a wealthy ecosystem of libraries that make it a perfect language for knowledge evaluation. A kind of libraries is pandas, which simplifies the method of studying and writing knowledge between in-memory knowledge constructions and totally different file codecs.

Nonetheless, whereas working with Excel recordsdata utilizing pandas.read_excel, you would possibly run into an error that appears like this:

xlrd.biffh.XLRDError: Excel xlsx file; not supported

On this Byte, we’ll dissect this error message, perceive why it happens, and discover ways to repair it.

What’s the Error “xlrd.biffh.XLRDError”

The xlrd.biffh.XLRDError is a selected error message that you just would possibly encounter whereas working with the pandas library in Python. This error is thrown whenever you attempt to learn an Excel file with the .xlsx extension utilizing pandas.read_excel methodology.

Here is an instance of the error:

import pandas as pd

df = pd.read_excel('file.xlsx')


xlrd.biffh.XLRDError: Excel xlsx file; not supported

Explanation for the Error

The xlrd.biffh.XLRDError error is brought on by a latest change within the xlrd library that pandas makes use of to learn Excel recordsdata. The xlrd library now solely helps the older .xls file format and now not helps the newer .xlsx file format.

This alteration is usually a little bit of a shock in the event you’ve been utilizing pandas.read_excel with xlrd. By default, pandas.read_excel makes use of the xlrd library to learn Excel recordsdata, however as of xlrd model 2.0.0, this library now not helps .xlsx recordsdata.

As builders, we have all been there…

Learn how to Repair the Error

The answer to this error is straightforward. You simply want to put in openpyxl and specify the engine argument within the pandas.read_excel methodology to make use of the openpyxl library as an alternative of xlrd. The openpyxl library helps each .xls and .xlsx file codecs.

Here is do it:

First, you’ll want to set up the openpyxl library. You are able to do this utilizing pip:

$ pip set up openpyxl

Then, you possibly can specify the engine argument within the pandas.read_excel methodology like this:

import pandas as pd

df = pd.read_excel('file.xlsx', engine='openpyxl')

This code will learn the Excel file utilizing the openpyxl library, and you’ll now not encounter the xlrd.biffh.XLRDError error.


On this Byte, we have discovered in regards to the xlrd.biffh.XLRDError error that occurs when utilizing pandas.read_excel to learn .xlsx recordsdata. We have discovered why this error happens and repair it through the use of the openpyxl library.

Supply hyperlink

Related Articles


Please enter your comment!
Please enter your name here

Latest Articles