How to fetch the cell value of excel sheet

see faq 2208

We are not clear with faq2208, so can you please explain with simple example.

i have few questions on that faq,
1)Is i need to convert xlsx to csv,if yes help me to convert

please provide fully coded explanation

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.

```

please consult the docs of the xlrd module as mentioned in the faq

xlrd allows, to directly access Excel sheets per cell and more.

converting the Excel sheet to csv is a fallback option and should always work.

The docs for every Python module have code examples and the net is full of it.

If you are using Sikuli IDE, try following codes.

import xlrd
import datetime
EXCELFILE = "C:\\temp\\book1.xls"

book = xlrd.open_workbook(EXCELFILE)
sheet = book.sheet_by_index(0)
for col in range(sheet.ncols):
    for row in range(sheet.nrows):
        celltype = sheet.cell_type(row,col)
        value = sheet.cell_value(row,col)
        if celltype == 1:
            print "col:%d row:%d value:%s" % (col,row,value)
        elif celltype == 2:
            print "col:%d row:%d value:%d" % (col,row,value)
        elif celltype == 3:
            s = datetime.datetime(*xlrd.xldate_as_tuple(value,book.datemode)).strftime("%Y/%m/%d %H:%M:%S")
            print "col:%d row:%d value:%s" % (col,row,s)

Thanks masuo, that solved my question.

Thanks masuo,

The above code imported all my excel sheet values,but i want to fetch a single column (For ex: cell: H41) and i want to paste that values in m application text field

When strings is in cell H41

row = 40
col = 7
value = sheet.cell_value(row,col)

click("textbox.png") #click your application text field
paste(value) #paste strings from CELL

masuo thanks alot,

This solved my problem..

Friends here is my case -

Step 1: Fetch the value of a CELL from one Excel sheet
status: success
Step 2: Paste that value in another cell (say C30) in another Excel sheet
status: Not success.

Need help for acheiving Step 2.

TiA !

@Bharati A:

1. Please do not piggyback on somebody else's question, but create a new question document for your problem. There is no way that the status of your problem can be tracked, because the original question document is already marked as "solved".

2. xlrd (Excel Read) provides functionality to READ information form excel files and does not allow changing them.
You have to use other software. Maybe xlwt (Excel Write) can help with your problem.

Thanks Manfred for those pointers !