xlrd_xls_workbook_sheet_cell_iteration_quickstart.py

1import xlrd
2
3# Open the workbook
4book = xlrd.open_workbook("sample.xls")
5
6# Print the number of worksheets
7print("The number of worksheets is {0}".format(book.nsheets))
8
9# Print the names of the worksheets
10print("Worksheet name(s): {0}".format(book.sheet_names()))
11
12# Load the first worksheet by index
13sh = book.sheet_by_index(0)
14
15# Print the name and dimensions of the sheet
16print("{0} {1} {2}".format(sh.name, sh.nrows, sh.ncols))
17
18# Print the value of a specific cell (Row 1, Column 0)
19print("Cell D30 is {0}".format(sh.cell_value(rowx=29, colx=3)))
20
21# Iterate through all rows and print the values
22for rx in range(sh.nrows):
23    print(sh.row(rx))