def createExcel(fname, data):
wb = xlwt.Workbook(encoding='utf-8', style_compression=0)
# 写入sheet1
writeDataToSheet1(wb, data['listtop'],data['TotalDict'])
# 写入sheet2
writeDataToSheet2(wb, data['retdetail'])
excel.saveToExcel(fname,wb)
def createExcel(fname, data):
wb = xlwt.Workbook(encoding='utf-8',style_compression=0)
#写入sheet1
writeDataToSheet1(wb,data['listTop'],data['TotalDict'])
#写入sheet2,sheet3
writeDataToSheet2(wb,data['listShops'],data['listShopTotal'],data['listDept'])
excel.saveToExcel(fname,wb)
def createExcel(fname, data):
wb = xlwt.Workbook(encoding='utf-8', style_compression=0)
# 写入sheet1
writeDataToSheet1(wb, data['lis10'])
# 写入sheet2
writeDataToSheet2(wb, data['lis11'])
# 写入sheet3
writeDataToSheet3(wb, data['lis12'])
# 写入sheet4
writeDataToSheet4(wb, data['lis13'])
# 写入sheet5
writeDataToSheet5(wb, data['lis14'])
# 写入sheet6
writeDataToSheet6(wb, data['lis15'])
# 写入sheet7
writeDataToSheet7(wb, data['lis16'])
# 写入sheet8
writeDataToSheet8(wb, data['lis17'])
# 写入sheet9
writeDataToSheet9(wb, data['lis2'])
# 写入sheet10
writeDataToSheet10(wb, data['lis3'])
# 写入sheet11
writeDataToSheet11(wb, data['lis4'])
excel.saveToExcel(fname,wb)
def createExcel(fname,data):
wb = xlwt.Workbook(encoding='utf-8', style_compression=0)
# 写入sheet1
writeDataToSheet1(wb, data['rlist'])
# 写入sheet2
writeDataToSheet2(wb, data['dlist'])
excel.saveToExcel(fname,wb)
def createExcel(fname,date,rslist, shoplist, grslist, srslist):
wb = xlwt.Workbook(encoding='utf-8', style_compression=0)
# 写入sheet1 门店
writeDataToSheet1(wb, rslist, date)
# 写入sheet2 类别
writeDataToSheet2(wb, grslist, date)
# 写入sheet4 各个门店类别
writeDataToSheetN(wb, shoplist, srslist, date)
excel.saveToExcel(fname, wb)
def export(fname,yesterday):
if not excel.isExist(fname):
data = query(yesterday)
createExcel(fname, data['rlist'])
res = {}
res['fname'] = fname
return HttpResponse(json.dumps(res))
def export(fname,date):
if not excel.isExist(fname):
data = query(date)
createExcel(fname, data)
res = {}
res['fname'] = fname
return HttpResponse(json.dumps(res))
def export(fname, sgroupid, yesterday):
if not excel.isExist(fname):
data = query(sgroupid, yesterday)
createExcel(fname, data)
res = {}
res["fname"] = fname
return HttpResponse(json.dumps(res))
def export(fname,date,start,end,yesterday,lastDay):
if not excel.isExist(fname):
data = query(date, start, end, yesterday, lastDay)
createExcel(fname, date, data['rlist'], data['shoplist'], data['grslist'], data['srslist'])
res = {}
res['fname'] = fname
return HttpResponse(json.dumps(res))
def createExcel(fname,data):
wb = xlwt.Workbook(encoding='utf-8',style_compression=0)
writeDataToSheet1(wb,data)
excel.saveToExcel(fname, wb)
def createExcel(fname, data):
wb = xlwt.Workbook(encoding='utf-8',style_compression=0)
#写入sheet1 月累计销售报表
writeDataToSheet1(wb,data['gslist'],data['sumDict'])
excel.saveToExcel(fname,wb)
def createExcel(fname, data):
wb = xlwt.Workbook(encoding="utf-8", style_compression=0)
writeDataToSheet2(wb, data["resList"], data["title"])
excel.saveToExcel(fname, wb)
