python读取excel学习(1)

#coding=gbk
#coding=utf-8
import xlrd
table = 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-----')

 

转载于:https://www.cnblogs.com/AIHEN/p/9011646.html