python讀取excel學習(1)

標籤：for   ble   code   gbk   tab   mes   open   --   print   

#coding=gbk#coding=utf-8import xlrdtable = xlrd.open_workbook(r‘E:\test.xlsx‘)#sheet = table.sheets()[0]#讀取表格#row = sheet.row_values(0)#讀取一行#row = sheet.row_values(0)[0]#讀取某一行與某一列的交集#col = sheet.col_values(0)#讀取一列#col = sheet.col_values(0)[0]#讀取一列某一行的交集table.sheet_names()#a = table.sheet_by_index(0) b = table.sheet_by_index(0) #for cols in range(b.ncols):#    print(b.col_values(cols)) for cols in range(b.ncols):    c = b.col_values(cols)      print(c)    print(‘end‘)  #     for d in c:#         print(d)#         print(‘-------test-----‘)

 

python讀取excel學習(1)