import xlrd
workbook = xlrd.open_workbook('book.xls')
for sheet in workbook.sheets():
    for row in range(sheet.nrows):
        for column in range(sheet.ncols):
            print('row::::: ', row)
print('column:: ', column)
print('value::: ', sheet.cell(row, column).value)
How to get line number in excel sheet using python?