← Back to team overview

sikuli-driver team mailing list archive

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.