vue配合django实现导出excel功能

秦羽 2020-06-24 PM 940℃ 0条

- 前端代码
```javascript
// 导出excel
    analysisExportExcel() {
      this.exportExcelLoading = true;
      designOpera({
        opera_type: "analysis_export_excel",
        wjId: this.wjId
      }).then(data => {
        this.doDownload(data.b64data, data.filename);
        this.exportExcelLoading = false;
      });
    },
doDownload(data, filename) {
      var b64data = data; //base64数据
      var bdata = this.dataURLtoBlob(b64data);
      if (!b64data) {
        return;
      }
      let url = window.URL.createObjectURL(new Blob([bdata]));
      let link = document.createElement("a");
      link.style.display = "none";
      link.href = url;
      link.setAttribute("download", filename);

document.body.appendChild(link);
      link.click();
    },
    dataURLtoBlob(dataurl) {
      console.log(dataurl);
      var bstr = atob(dataurl),
        n = bstr.length,
        u8arr = new Uint8Array(n);
      while (n--) {
        u8arr[n] = bstr.charCodeAt(n);
      }
      return u8arr;
    },
```

- 后端代码
```python
def opera(request):
    response={'code':0,'msg':'success'}
    if request.method=='POST':
        body=str(request.body,encoding='utf-8')
        print(body)
        try:
            info = json.loads(body)#解析json报文
        except:
            response['code'] = '-2'
            response['msg'] = '请求格式有误'
        else:
            opera_type = info.get('opera_type')  # 获取操作类型
            username = request.session.get('username')
            if opera_type:#如果操作类型不为空
                    if opera_type=='analysis_export_excel':
                        response=analysisExportExcel(info)
                    else:
                        response['code'] = '-7'
                        response['msg'] = '请求类型有误'
            else:
                response['code'] = '-3'
                response['msg'] = '确少必要参数'
    else:
        response['code']='-1'
        response['msg']='请求方式有误'
    return HttpResponse(json.dumps(response))
# 导出excel
def analysisExportExcel(info):
    response = {'code': 0, 'msg': 'success'}
    wjId=info.get('wjId')
    if not wjId:
        response['code'] = '-3'
        response['msg'] = '确少必要参数'
        return response
    wj=Wj.objects.get(id=wjId)
    title=wj.title
    data=dataAnalysis(info)
    if data['code']==0:
        detail=data['detail']
        wb=handle.analysisExportExcel(detail,title)#返回已写入数据的Workbook对象
        bio = BytesIO()
        wb.save(bio)
        bio.seek(0)
        response['filename']='%s.xls'%title
        response['b64data']=base64.b64encode(bio.getvalue()).decode()
        return response
    else:
        return response
```

标签: python, vue, django, excel导出, 文件下载

非特殊说明，本博所有文章均为博主原创。

如若转载，请注明出处：https://www.qinyu.cc/archives/47.html

上一篇 table中的td里面的div设置height100%无效的问题

下一篇 linux安装mysql8.0详细教程

vue配合django实现导出excel功能

评论啦~

栏目分类

标签云

友情链接申请

vue配合django实现导出excel功能

 评论啦~

 栏目分类

标签云

友情链接申请

评论啦~

栏目分类

标签云

友情链接申请