论坛 › Python › Python中生成（写入数据到）Excel文件 by xlwt

甩祸 发表于 2017-5-6 09:04:22

Python中生成（写入数据到）Excel文件 by xlwt

import xlwt
wb = xlwt.Workbook();
ws = wb.add_sheet('report');
ws.write(0, 0, "max_len="+str(result2));
ws.write(0, 1, "max_lev="+str(result2));
ws.write(0, 2, "min_len="+str(result2));
ws.write(0, 3, "min_lev="+str(result2));
ws.write(0, 4, "sum_len="+str(result3))
ws.write(0, 5, "sum_lev="+str(result3));
ws.write(0, 6, "url_1="+url_1);
ws.write(0, 7, "url_2="+url_2);
ws.write(2, 0, "time_num");
ws.write(2, 1, "data1");
ws.write(2, 2, "data2");
ws.write(2, 3, "len");
ws.write(2, 4, "lev");
for index in range(len(result1)):
ws.write(3+index,0,str(result1))
ws.write(3+index,1,str(result1))
ws.write(3+index,2,str(result1))
ws.write(3+index,3,str(result1))
ws.write(3+index,4,str(result1))
wb.save(start_time+"-"+end_time+" report.xls");

查看完整版本: Python中生成（写入数据到）Excel文件 by xlwt