import xlrd
loc = ("/tmp/Students.xlsx")
wb = xlrd.open_workbook(loc)
sheet1 = wb.sheet_by_index(0)
sheet2 = wb.sheet_by_index(1)
#Sheet1
for i in range(1, sheet1.nrows):
each_list = sheet1.row_values(i)
print each_list
#Sheet2
for i in range(1, sheet1.nrows):
each_list = sheet2.row_values(i)
print each_list
loc = ("/tmp/Students.xlsx")
wb = xlrd.open_workbook(loc)
sheet1 = wb.sheet_by_index(0)
sheet2 = wb.sheet_by_index(1)
#Sheet1
for i in range(1, sheet1.nrows):
each_list = sheet1.row_values(i)
print each_list
#Sheet2
for i in range(1, sheet1.nrows):
each_list = sheet2.row_values(i)
print each_list
No comments:
Post a Comment