下载当前数据导出至excel

    userlogin = UserLogin.objects(**condition).order_by("-login_time")

    try:
        # 下载excel
        if request.GET.get(‘excel‘) == ‘true‘:
            response = HttpResponse(mimetype=‘application/vnd.ms-excel‘)
            response[‘Content-Disposition‘] = ‘attachment;filename=登录数据明细%s.xls‘ % str(date_str)
            wb = xlwt.Workbook(encoding=‘utf-8‘)
            sheet = wb.add_sheet(u‘登录数据明细‘)
            headers = (‘用户ID‘, ‘微信昵称‘, ‘用户类型‘, ‘微信授权手机‘, ‘登录时间‘)
            for i, header in enumerate(headers):
                sheet.write(0, i, header)
            row = 1
            for i, item in enumerate(userlogin):
                sheet.write(row, 0, item.user_id)
                sheet.write(row, 1, item.nickname)
                sheet.write(row, 2, item.user_role)
                sheet.write(row, 3, item.mobile)
                sheet.write(row, 4, str(item.login_time))
                row += 1
            output = StringIO.StringIO()
            wb.save(output)
            output.seek(0)
            response.write(output.getvalue())
            return response

    <a class="btn btn-primary top10" target="_blank" href="/super_manage/logindata_stats/?login_time_start={{ login_time_start }}&login_time_end={{ login_time_end }}&excel=true">下载当前数据</a>