#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-----')
