LM19 2021-09-21 10:20 采纳率: 61.5%
浏览 41
已结题

vue使用Export2Excel下载后端到excel,但没有数据

我使用Vue前端通过下面代码,接收后端的数据,然后下载到excel文件中,但生成的excel文件中没有数据,这是怎么回事呢,请帮助修改一下,谢谢了!

methods: {
  download() {
      this.axios({
        method: 'get',
        url: 'http://127.0.0.1:8000/app1/show_r3data/'
      }).then((response) => {
        const {export_json_to_excel} = require('@/vendor/Export2Excel')
        const tHeader = ['单号', '站号', '建立日期']
        const filterVal = ['guanjian', 'werkstatt', 'createdate']
        const list1 = response.data.list
        const data = this.formatJson(filterVal, list1)
        export_json_to_excel(tHeader, data, '数据' + '_' + this.formatDate())
      });

    },
    formatJson(filterVal, jsonData) {
      return jsonData.map(v => filterVal.map(j => v[j]))
    },
    formatDate() { // 部分标题名
      let time = new Date()
      let year = time.getFullYear()
      let month = time.getMonth() + 1
      let day = time.getDate()
      let hour = time.getHours()
      let minute = time.getMinutes()
      let seconds = time.getSeconds()
      return year + "" + month + "" + day + "" + hour + "" + minute + "" + seconds
    },

}

img

从后端传过来的数据如下:
{"list": [{"model": "myDjangoVue.r3data", "pk": "05c64952-f128-4ca8-993a-c643618dfabc", "fields": {"guanjian": "112411904", "werkstatt": "7581124", "antragsnr": "11904", "createdate": "20200713", "leitdaten": "1111", "provinz": "\u5317\u4eac\u5e02", "cheleixing": "L", "modell": "032FY", "schadteil": "7Q0 123 243", "nameschad": "\u6cf5", "hersteller": "A4A", "ergebnis": "\u53d1\u52a8\u673a\u6545\u969c\u706f\u4eae\uff0c\u8bca\u65ad\u6cf5\u6545\u969c\u3002\u66f4\u6362", "dipan": "LGM2A23C9A3045572", "motornr18": "DABNR0922", "getriebenr": "BESC021074D210113I", "zulassung": "2021-06-09", "cpdate": "2021-03-25", "km": 4190, "redatum": "2021-08-12", "kd": "2048", "rukudate": "2021-08-18", "teilstatus": "22", "status": "2", "chukudate": "1900-01-01", "lingyong": "", "auftragsnr": "1-20090810045", "costen": 321.83, "cx2": "03", "motordatum": "1900-01-01", "getrdatum": "1900-01-01", "dtcc": "-", "guzhangjianshu": "-", "brand": "-", "motorwerk": "-", "getriebe_werk": "-"}}, {"model": "myDjangoVue.r3data", "pk": "c4ca3c22-efc5-4719-9e2e-34e69c4c77e0", "fields": {"guanjian": "112411875", "werkstatt": "7581124", "antragsnr": "11875", "createdate": "20200711", "leitdaten": "1111", "provinz": "\u5317\u4eac\u5e02", "cheleixing": "", "modell": "022FY", "schadteil": "0AA 198 142", "nameschad": "\u7ef4\u4fee\u5957\u4ef6", "hersteller": "7AB", "ergebnis": "\u4e00\u6863\u5347\u4e8c\u6863\u4e0d\u52a0\u6cb9\u8f66\u6296\uff0c\u591a\u8def\u79bb\u5408\u5668\u6545\u969c\u3002\u66f4\u6362", "dipan": "LGM2A23C7K3054395", "motornr18": "DABN29052", "getriebenr": "DESC010547D190304-", "zulassung": "2019-08-15", "cpdate": "2019-04-11", "km": 53963, "repdatum": "2021-08-10", "kd": "3060", "rukudate": "2021-08-20", "teilstatus": "2", "status": "2", "chukudate": "1900-01-01", "lingyong": "", "auftragsnr": "1-20210810033", "costen": 8570.68, "cx2": "02", "motordatum": "1900-01-01", "getrdatum": "1900-01-01", "dtcc": "-", "guzhangjianshu": "-", "brand": "-", "motorwerk": "-", "getriebe_werk": "-"}}], "msg": "success", "error_num": 0}

  • 写回答

3条回答 默认 最新

  • 瞎写点 2021-09-21 11:22
    关注

    大概是因为你要导出的这些数据并不是放在数组对象的表层,导致找不到对应数据吧,你应该把每个对象里的fields提出来

    img

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

问题事件

  • 系统已结题 9月29日
  • 已采纳回答 9月21日
  • 创建了问题 9月21日

悬赏问题

  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号
  • ¥15 基于单片机的靶位控制系统
  • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度
  • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测