The following Python program reads data from the spreadsheet.
Created on 15-Mar-2013
from xlrd import open_workbook
# Read row by row
for rownum in range(sheetIO.nrows):
rowValues = sheetIO.row_values(rownum)
rollNo = rowValues
name = rowValues
print rollNo, name
if __name__ == '__main__':
bookTestData = open_workbook("C:/pythontests/sample-spreadsheet.xls")
sheetIO = bookTestData.sheet_by_name('Sheet1')
In the above code, xlrd package is used for accessing the workbook. Note that the excel file should have the extension xls.
In the above example, the name of the excel file is sapmple-spreadsheet.xls. The name of the worksheet is Sheet1 and it has two columns namely, rollNo and name.