import xlrd
book=xlrd.open_workbook('new_stu.xls')#打開一個(gè)excel
sheet=book.sheet_by_index(0)#根據(jù)順序獲取sheet
sheet2=book.sheet_by_name('sheet1')#根據(jù)sheet頁名字獲取sheet
print(sheet.cell(0,0).value)#指定行和列獲取數(shù)據(jù)
print(sheet.cell(0,1).value)#指定行和列獲取數(shù)據(jù)
print(sheet.cell(0,2).value)#指定行和列獲取數(shù)據(jù)
print(sheet.cell(0,3).value)#指定行和列獲取數(shù)據(jù)
print(sheet.ncols)#獲取excel里面有多少列
print(sheet.nrows)#獲取excel里面有多少行
print(sheet.get_rows())
for i in range(sheet.nrows):#0,1,2,3,4,5
print(sheet.row_values(i))#取第幾行的數(shù)據(jù)
for i in range(sheet.ncols):
print(sheet.col_values(i))
##################################
