1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| f = xlwt.Workbook() sheet1 = f.add_sheet('sheet1', cell_overwrite_ok=True) headers = ['序号', "姓名", '列表', '1月', '2月', '3月', '4月', '5月'] name = ['1-AAA', '2-BBB', '3-CCC', '4-DDD'] status = ['累计应发数', '累计专项扣除-五险一金', '累计免税收入', '累计扣个税']
for i in range(0,len(headers)): sheet1.write(0,i,headers[i])
i, j = 1, 0 while i < 10*len(name) and j < len(name): sheet1.write_merge(i,i+9,0,0,name[j].split('-')[0]) sheet1.write_merge(i,i+9,1,1,name[j].split('-')[1]) i += 10 j += 1
i = 0 while i < 10*len(column0): for j in range(0,len(status)): sheet1.write(j+i+1,3,status[j]) i += 10
f.save(path)
|