前端使用xlsx导出

引入工具外部链接

1、 在html页面中引入https://unpkg.com/xlsx/dist/xlsx.full.min.js外部链接

2，新建一个文件定义一个方法

export const exportTable = (cloum,data,name)=>{  cloum//是表头 data//是数据 name//是文件名称
    const sheet2blob = (sheet, sheetName)=> {
        sheetName = sheetName || 'sheet1';
        var workbook = {
          SheetNames: [sheetName],
          Sheets: {}
        };
        workbook.Sheets[sheetName] = sheet;
        // 生成excel的配置项
        var wopts = {
          bookType: 'xlsx', // 要生成的文件类型
          bookSST: false, // 是否生成Shared String Table，官方解释是，如果开启生成速度会下降，但在低版本IOS设备上有更好的兼容性
          type: 'binary'
        };
        var wbout = XLSX.write(workbook, wopts);
        var blob = new Blob([s2ab(wbout)], {type:"application/octet-stream"});
        // 字符串转ArrayBuffer
        function s2ab(s) {
          var buf = new ArrayBuffer(s.length);
          var view = new Uint8Array(buf);
          for (var i=0; i!=s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF;
          return buf;
        }
        return blob;
      }
    const openDownloadDialog = (url, saveName)=>{
      	if(typeof url == 'object' && url instanceof Blob)
      	{
      		url = URL.createObjectURL(url); // 创建blob地址
      	}
      	var aLink = document.createElement('a');
      	aLink.href = url;
      	aLink.download = saveName || ''; // HTML5新增的属性，指定保存文件名，可以不要后缀，注意，file:///模式下不会生效
      	var event;
      	if(window.MouseEvent) event = new MouseEvent('click');
      	else
      	{
      		event = document.createEvent('MouseEvents');
      		event.initMouseEvent('click', true, false, window, 0, 0, 0, 0, 0, false, false, false, false, 0, null);
      	}
      	aLink.dispatchEvent(event);
      }
      var newColumns = JSON.parse(JSON.stringify(cloum))
      newColumns.splice(0,1)
      newColumns.splice(newColumns.length-1,1)
      let exportData = []
      let columnsData = []
      let datas = []
      newColumns.forEach(element => {
        columnsData.push(element.title)
      })
      data.forEach(res => {
        const value = []
        for(var k in res){
          newColumns.map((ress,index)=>{
            if(k==ress.key){
              if(res[k]!==null){
                if(k=='amountPaidActual'){
                  value[index] = ((res[k] != null&&res['status'] != 0) ? res[k] : '')
                }else{
                  value[index] = res[k]
                }
                console.log(k,res[k])
              }else{
                value[index] = '--'
              }
            }
          })
        }
        datas.push(value)
      })
      exportData = [columnsData].concat(datas)
      var sheet = XLSX.utils.aoa_to_sheet(exportData);
      openDownloadDialog(sheet2blob(sheet), `${name}.xlsx`);
}