+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Selecting correct xlrd version (/thread-41648.html)
Selecting correct xlrd version - Kithsiri - Feb-22-2024
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.
RE: Selecting correct xlrd version - Pedroski55 - Feb-22-2024
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?
RE: Selecting correct xlrd version - Kithsiri - Feb-22-2024
Yes I have to stick to xlrd at the moment and this older version (.8) support xlsx format.
RE: Selecting correct xlrd version - snippsat - Feb-22-2024
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
RE: Selecting correct xlrd version - Kithsiri - Feb-27-2024
This is the extract answer that i am expecting.
Thanks a lot.