How To Fix “xlrd.biffh.XLRDError: Excel xlsx file; not supported in python”?
Are you having problems with the issue “xlrd.biffh.XLRDError: Excel xlsx file; not supported in python“? How to fix it? In today’s article, I will provide solutions for you to solve the issues. Please follow the below steps to get the problem resolved now
How did “xlrd.biffh.XLRDError: Excel xlsx file; not supported in python” occur?
xlrd.biffh.XLRDError: Excel xlsx file; not supported in python
When you work with Python, you may get the issue xlrd.biffh.XLRDError: Excel xlsx file; not supported in python. Don’t worry, we are here to provide you solutions in order to resolve your problem.
How to fix “xlrd.biffh.XLRDError: Excel xlsx file; not supported in python”?
Question : How to Solve xlrd.biffh.XLRDError: Excel xlsx file; not supported ?
Answer: The latest version xlrd (2.01) does not support.xls files. I was able to open.xlsx files by installing the older version 1.2.0.
Solution 1
I was able to open.xlsx files by installing the older version 1.2.0.
Solution 2
- Only.xls files are supported by the latest version of xlrd (version 2.0.1).
- Installing an older version can solve this problem if you are willing to take on security risks and allow files to be parsed incorrectly.
- The command below can be used in a shell prompt or cmd prompt
pip install xlrd==1.2.0
Solution 3
This is because of potential security flaws in xlrd version 1.2.2 or earlier to read.xlsx files.
The solution in your case is to:
- install openpyxl: https://openpyxl.readthedocs.io/en/stable/
- Change your pandas code so that it says:
pandas.read_excel(‘cat.xlsx’, engine=’openpyxl’)
Solution 4
Only.xls files are supported by the latest version of xlrd (version 2.0.1).
Installing an older version of the xlrd can solve this problem if you are willing to take on security risks and allow files to be parsed incorrectly.
The command below can be used in a shell prompt or cmd prompt
pip install xlrd==1.2.0
Final words
The above are useful solutions that can help you fix “xlrd.biffh.XLRDError: Excel xlsx file; not supported in python” problem, if you can’t solve it well. Please leave a message.