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)