写入
def write_test():
# 1 先创建个工作簿
wbook = xlwt.Workbook(encoding="utf-8", style_compression=0)
# 2 添加个表
wsheet = wbook.add_sheet(sheetname="one")
# 3 写入,参数说明:行,列,值
wsheet.write(0, 0, '姓名')
wsheet.write(0, 1, '年龄')
wsheet.write(1, 0, '张三')
wsheet.write(1, 1, '33')
# 保存
wbook.save('test.xls')
读取
def read_test():
# 1 打开excel文件
data = xlrd.open_workbook('test.xls')
# 2 获取第一张工作表(通过索引的方式)
table = data.sheets()[0]
# 3 遍历打印数据
for row in range(table.nrows):
print(table.row_values(row))