Python Program for reading xls

readXLS.py

# coding: utf-8

from xlrd import open_workbook

wb = open_workbook('simple.xls')
for sheet in wb.sheets():
	print(u'Sheet:' + sheet.name)

print("Number of Sheets: " + str(wb.nsheets))


for sheet_index in range(wb.nsheets):
	sheet = wb.sheet_by_index(sheet_index)
	print(u'Sheet Name: ' + sheet.name)
	print(u'Sheet Rows: ' + str(sheet.nrows))
	print(u'Sheet Cols: ' + str(sheet.ncols))

	for row_index in range(sheet.nrows):
		for col_index in range(sheet.ncols):
			print("Type("+str(row_index)+","+str(col_index)+"): "+str(sheet.cell(row_index, col_index).ctype))
			print("Value("+str(row_index)+","+str(col_index)+"): "+sheet.cell(row_index, col_index).value)


	for row_index in range(sheet.nrows):
		for col_index in range(sheet.ncols):
			print(sheet.cell_value(row_index, col_index))	
			print(sheet.cell_type(row_index, col_index))


sheet_0 = wb.sheet_by_index(0)
row0_1 = sheet_0.row_slice(0,1)
print(row0_1[0])
print(row0_1[1])