django excel 导出页面_django把页面数据导出excel文件

#导出excel表格数据defdatainput(request):

type = request.GET.get('activity','')

key = request.GET.get('gjz','')

timereport =request.GET.get('dateTime','')

iftimereport != '':

a = timereport[:10]

b = timereport[-10:]+'/23/59/59'c = datetime.strptime(a,'%Y-%m-%d')

d = datetime.strptime(b,'%Y-%m-%d/%H/%M/%S')

iftype == '0':

ifkey != '':

activity_list=Order.objects.filter(activity_id__start_date__gte=c).filter(activity_id__start_date__lte=d).filter(activity_id__name__contains=key).values_list( 'activity_id__name','name','start_time','end_time','report_order__zhibo_click','report_order__zhibo_read','report_order__zhibo_call','activity_id__start_date','activity_id__end_date','activity_id__advertiser_name')

else:

activity_list=Order.objects.filter(activity_id__start_date__gte=c).filter(activity_id__start_date__lte=d).values_list('activity_id__name','name','start_time','end_time','report_order__zhibo_click','report_order__zhibo_read','report_order__zhibo_call','activity_id__start_date','activity_id__end_date','activity_id__advertiser_name')

else:

ifkey != '':

activity_list = Order.objects.filter(activity_id__start_date__gte=c).filter(activity_id__start_date__lte=d).filter(activity_id__id__contains=key).values_list( 'activity_id__name','name','start_time','end_time','report_order__zhibo_click','report_order__zhibo_read','report_order__zhibo_call','activity_id__start_date','activity_id__end_date','activity_id__advertiser_name')

else:

activity_list =Order.objects.filter(activity_id__start_date__gte=c).filter(activity_id__start_date__lte=d).values_list( 'activity_id__name','name','start_time','end_time','report_order__zhibo_click','report_order__zhibo_read','report_order__zhibo_call','activity_id__start_date','activity_id__end_date','activity_id__advertiser_name')

response = HttpResponse(content_type='application/vnd.ms-excel')

response['Content-Disposition'] = 'attachment; filename=reportdata.xls'# 返回下载文件的名称(activity.xls)workbook = xlwt.Workbook(encoding='utf-8') # 创建工作簿mysheet = workbook.add_sheet(u'活动') # 创建工作页rows=activity_list

cols = 10#每行的列aaa = ['活动名称','订单名称','投放日期','结束日期','直播点击数','直播订阅量','直播访问量','开始时间','结束时间','广告主名称'] #表头名forc inrange(len(aaa)):

mysheet.write(0,c,aaa[c])

forr inrange(0,len(rows)): #对行进行遍历forc inrange(cols): #对列进行遍历mysheet.write(r+1,c,str(rows[r][c]))

response = HttpResponse(

content_type='application/vnd.ms-excel') # 这里响应对象获得了一个特殊的mime类型,告诉浏览器这是个excel文件不是htmlresponse[

'Content-Disposition'] = 'attachment; filename=reportdata.xls'# 这里响应对象获得了附加的Content-Disposition协议头,它含有excel文件的名称,文件名随意,当浏览器访问它时,会以"另存为"对话框中使用它.workbook.save(response)

returnresponse