python django 模板 页面导出excel

使用python django 模板 页面导出excel示例

view.py
from io import BytesIO
import xlwt

# 导出Excel文件
def export_excel(request):
    city = request.POST.get('city')
    list_obj = [{'place': u'广东', 'sum': '120', 'lng': 1, 'lat': 2}, {'place': u'深圳', 'sum': '220', 'lng': 3, 'lat': 4}]
    # 设置HTTPResponse的类型
    response = HttpResponse(content_type='application/vnd.ms-excel')
    response['Content-Disposition'] = 'attachment;filename='+city+'.xls'
    """导出excel表"""
    if list_obj:
        # 创建工作簿
        ws = xlwt.Workbook(encoding='utf-8')
        # 添加第一页数据表
        w = ws.add_sheet('sheet1') # 新建sheet（sheet的名称为"sheet1"）
        # 写入表头
        w.write(0, 0, u'地名')
        w.write(0, 1, u'次数')
        w.write(0, 2, u'经度')
        w.write(0, 3, u'纬度')
        # 写入数据
        excel_row = 1

        for obj in list_obj:
            name = obj['place']
            sum = obj['sum']
            lng = obj['lng']
            lat = obj['lat']
            # 写入每一行对应的数据
            w.write(excel_row, 0, name)
            w.write(excel_row, 1, sum)
            w.write(excel_row, 2, lng)
            w.write(excel_row, 3, lat)
            excel_row += 1
        # 写出到IO
        output = BytesIO()
        ws.save(output)
        # 重新定位到开始
        output.seek(0)
        response.write(output.getvalue())
    return response

html

导出

function export_tasks()
    {
        var
    csrf =$('input[name="csrfmiddlewaretoken"]').val();
    const
    req = new
    XMLHttpRequest();
    req.open('POST', '/export_excel/', true);
    req.responseType = 'blob';
    req.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded'); // 设置请求头
    req.send('city=' +$('#city').val() + "&&csrfmiddlewaretoken=" + csrf); // 输入参数
    req.onload = function()
    {
        const data = req.response;
    const a = document.createElement('a');
    const blob = new Blob([data]);
    const blobUrl = window.URL.createObjectURL(blob);
    download(blobUrl);
    };

    }
Date.prototype.format = function (fmt) {
  var o = {
    "M+": this.getMonth() + 1,                   //月份
    "d+": this.getDate(),                        //日
    "h+": this.getHours(),                       //小时
    "m+": this.getMinutes(),                     //分
    "s+": this.getSeconds(),                     //秒
    "q+": Math.floor((this.getMonth() + 3) / 3), //季度
    "S": this.getMilliseconds()                  //毫秒
  };

  //  获取年份
  // ①
  if (/(y+)/i.test(fmt)) {
    fmt = fmt.replace(RegExp.$1, (this.getFullYear() + "").substr(4 - RegExp.$1.length));
  }

  for (var k in o) {
    // ②
    if (new RegExp("(" + k + ")", "i").test(fmt)) {
      fmt = fmt.replace(
        RegExp.$1, (RegExp.$1.length == 1) ? (o[k]) : (("00" + o[k]).substr(("" + o[k]).length)));
    }
  }
  return fmt;
}

function download(blobUrl) {
     const a = document.createElement('a');
     a.style.display = 'none';     
     var now = new Date();
     var nowStr = now.format("YYYYMMDDhhmmss");
     a.download = nowStr + '.xls';
     a.href = blobUrl;
     a.click();
     document.body.removeChild(a);
}
详细参考引用链接：https://www.jb51.net/article/182619.htm

​