Reading from Excel sheets (Python module xlrd and from Java)

----------------- for SikuliX 1.1.0+
Beginning with SikuliX 1.1.x we will use Jython 2.7 and the distribution will already contain the latest versions of modules xlrd, xlwt and xlutils ready to import.

A good overview: http://www.python-excel.org

---------------- for usage with Java
a good entry
http://stackoverflow.com/questions/14980717/what-is-the-better-api-to-reading-excel-sheets-in-java-jxl-or-apache-poi

This is relevant for SikuliX 1.0RC3 and SikuliX 1.0.1 (not recommended, use 1.1.1)
--------------------------------------------------------------------------------------------------------------------------

Download the module from
http://pypi.python.org/pypi/xlrd1

Take the newest version (currently 1.0.1)

Be aware of the mentioned restrictions and that it does not support xlsx.

*** These are the steps, to make it available:
- unzip the downloaded package somewhere
- in the folder there is a folder xlrd1 (containing a __init__.py file)
- in the Sikuli setup folder (RC3: Sikuli X program folder) make a new folder Lib
- into this folder Lib COPY the folder xlrd1 from the package

With this the import should work, because the folder …\...Sikuli...\Lib is already in sys.path by default

in script:
import xlrd1

*** looking for docs
xlrd1 is based on the original xlrd - download from here
http://pypi.python.org/packages/source/x/xlrd/xlrd-0.7.1.zip

This one contains some useful docs and examples in the contained xlrd folder and you might use this one as well.