xlsxwriter

import xlsxwriter

workbook = xlsxwriter.Workbook('火花学员信息')
worksheet=workbook.add_worksheet()
worksheetL1 = workbook.add_worksheet()
worksheetL2 = workbook.add_worksheet()
worksheetL3 = workbook.add_worksheet()
worksheetL4 = workbook.add_worksheet()
r1=[U'序号', U'名字',U'性别',U'手机',U'ID', U'等级',U'购买课时',U'已用课时',U'学费']
r2=[U'序号', U'时间',U'等级',U'课程']
for i in range (len(r1)):
worksheet.write_string(0,i,r1[i])

headings = ['Number','testA','testB']     #设置表头
data = [

    ['2017-9-1','2017-9-2','