vue导出带图片的excel

1680681569344.png

下载插件：

npm install js-table2excel

import table2excel from 'js-table2excel'

getphoto() {
      const column = [
        {
          title: '昵称', 
          key: 'title',
          type: 'text'
        },
        {
          title: '人脸照片',
          key: 'fximage',
          type: 'image',
          width: 100,
          height: 100
        },{
          title:'时间',
          key:'add_time',
          type:'text'
        }
      ]
      const data = [
      {
        title: 'xiao',
        fximage: 'https://xxxx.png',
        add_time: 1601887522   //时间戳
      },
      {
        title: '测试23',
        fximage: 'https://xxxx.png',
        add_time: 1601887522
      }
    ]
    var datas = this.Format(data)
      const excelName = '人脸照片'                //文件名称
    table2excel(column, datas, excelName)    //生成Excel表格，自动下载
    },
    Format(res){
      var list = res
      for (let index = 0; index < list.length; index++) {
        var time = list[index]["add_time"]
        var date = time * 1000;
        list[index]["add_time"] = '2022';
      }
      return list;
    },