close

[Fixed] xlrd.biffh.XLRDError: Excel xlsx file; not supported in python

Today We are Going To Solve xlrd.biffh.XLRDError: Excel xlsx file; not supported in python in Python. Here we will Discuss All Possible Solutions and How this error Occurs So let’s get started with this Article.

How to Fix xlrd.biffh.XLRDError: Excel xlsx file; not supported in python Error?

  1. How to Fix xlrd.biffh.XLRDError: Excel xlsx file; not supported in python Error?

    To Fix xlrd.biffh.XLRDError: Excel xlsx file; not supported in python Error just Change your Pandas code. First of all, make sure that you have the latest version of panda. If not than upgrade it. After it, install openpyxl by using pip install openpyxl And then change your Pandas code just like below: df1 = pd.read_excel( os.path.join(APP_PATH, "Data", "aug_latest.xlsm"), engine='openpyxl', )

  2. xlrd.biffh.XLRDError: Excel xlsx file; not supported in python

    To Fix xlrd.biffh.XLRDError: Excel xlsx file; not supported in python Error just Run the command. Just use the below command to solve your error. This will help you.
    pip install xlrd==1.2.0

Solution 1 : Change your Pandas code

First of all, make sure that you have the latest version of panda. If not than upgrade it.

After it, install openpyxl by using pip install openpyxl

And then change your Pandas code just like below:

df1 = pd.read_excel(
     os.path.join(APP_PATH, "Data", "aug_latest.xlsm"),
     engine='openpyxl',
)

Solution 2 : Run the command

Just use the below command to solve your error. This will help you.

pip install xlrd==1.2.0

Solution 3 : Install the older version like xlrd==1.2.0

Just install the older version like xlrd==1.2.0, this will help you to open .xlsx files. Try this.

Conclusion

So these were all possible solutions to this error. I hope your error has been solved by this article. In the comments, tell us which solution worked? If you liked our article, please share it on your social media and comment on your suggestions. Thank you.

Also Read These Solutions

Leave a Comment