sikuli-driver team mailing list archive
-
sikuli-driver team
-
Mailing list archive
-
Message #43311
Re: [Question #653759]: How to fetch the cell value of excel sheet
Question #653759 on Sikuli changed:
https://answers.launchpad.net/sikuli/+question/653759
Status: Open => Answered
Manfred Hampl proposed the following answer:
See the last paragraph of faq 2208
*** 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.
(Remark: the current version of xlrd is 1.0.0)
**Quick start**:
```
import xlrd
book = xlrd.open_workbook("myfile.xls")
print "The number of worksheets is", book.nsheets
print "Worksheet name(s):", book.sheet_names()
sh = book.sheet_by_index(0)
print sh.name, sh.nrows, sh.ncols
print "Cell D30 is", sh.cell_value(rowx=29, colx=3)
for rx in range(sh.nrows):
print sh.row(rx)
# Refer to docs for more details.
# Feedback on API is welcomed.
```
--
You received this question notification because your team Sikuli Drivers
is an answer contact for Sikuli.