Read data from excel sheet in python

Question

How to Read data from excel sheet in python. how to read data from excel sheet in selenium python framework?

Below is my code:

def getcell(rows,cols):

table=list()

record=list()

for x in range(rows):

    for y in range(cols):

        record.append(SheetName.cell(x,y).value)    

        table.append(record)

        record=[]

        rows=rows+1

return table;

print(table)

Answer 1

Try to use xrld. A python module used to read MS excel sheets.

This example will help you:

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)