Python Forum

Our system is using Python 2 and xlrd 0.8 version. We are planning to upgrade to Python 3.
Then looking at xlrd 0.8 version, it is very much dependent on Python 2.
As our system support both versions of excel format, .xlsx and .xls, we can't use xlrd latest version.

I want to know, what is the most suitable xlrd version which support Python 3 and all of the features of xlrd 0.8.

Quote:Warning

This library will no longer read anything other than .xls files. For alternatives that read newer file formats, please see http://www.python-excel.org/.

Sure you want xlrd?

Why not try openpyxl?

Yes I have to stick to xlrd at the moment and this older version (.8) support xlsx format.

Version 1.2.0 may be your best option.
This version is compatible with Python 3 and retains support for both formats(.xlsx and .xls),
making it the closest match to the xlrd 0.8 features with Python 3 support.

pip install xlrd==1.2.0

This is the extract answer that i am expecting.
Thanks a lot.