首页 > 应用开发 > > python操作excel问题求解?
#coding=gbk
#coding=utf-8
import xlrd
table = xlrd.open_workbook(r'E:\test.xlsx')
#读取表格
#sheet = table.sheets()[0]
#读取一行
#row = sheet.row_values(0)
#读取一列
#col = sheet.col_values(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-----')
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/818/viewspace-3147220/ ,如需转载,请注明出处,否则将追究法律责任。