Cannot find python xlrd version

python excel version packages xlrd
Paul Avery picture Paul Avery · May 31, 2013 · Viewed 8.4k times · Source

I have been using xlrd within python. However, xlrddoes not seem to provide a standard way to find its version number! I have tried:

  • xlrd.version()
  • xlrd.__version__
  • xlrd.version
  • xlrd.VERSION
  • xlrd.VERSION()

Answer

alecxe picture alecxe · Jun 2, 2013

You've almost got it: xlrd.__VERSION__.

Usually it's useful to see available attributes and methods by calling dir: dir(xlrd).

You can even iterate through the results of dir() see if version is inside:

>>> import xlrd
>>> getattr(xlrd, next(item for item in dir(xlrd) if 'version' in item.lower()))
'0.9.3'

A more reliable way, that would work for any installed package, is to use pkg_resources:

>>> import pkg_resources
>>> pkg_resources.get_distribution("xlrd").version
'0.9.3'

Related questions

Writing to an Excel spreadsheet

I am new to Python. I need to write some data from my program to a spreadsheet. I've searched online and there seem to be many packages available (xlwt, XlsXcessive, openpyxl). Others suggest to write to a .csv file (never …

Read More
IndexError: too many indices for array

I know there is a ton of these threads but all of them are for very simple cases like 3x3 matrices and things of that sort and the solutions do not even begin to apply to my situation. So I'm …

Read More
Read Excel File in Python

I've an Excel File Arm_id DSPName DSPCode HubCode PinCode PPTL 1 JaVAS 01 AGR 282001 1,2 2 JaVAS 01 AGR 282002 3,4 3 JaVAS 01 AGR 282003 5,6 I want to save a string in the form Arm_id,DSPCode,Pincode. This format is configurable, i.e. it might change to …

Read More