導(dǎo)出需要引入 https://www.npmjs.com/package/xlsx
核心代碼如下：

      let s2ab = function (s) {
        if (typeof ArrayBuffer !== 'undefined') {
          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;
        } else {
          var buf = new Array(s.length);
          for (var i = 0; i != s.length; ++i) buf[i] = s.charCodeAt(i) & 0xff;
          return buf;
        }
      };

            const header = ['name', 'abbrName']; //定義展示順序
            const headerText = { name: '名稱', abbrName: '縮寫名稱' };
            // https://www.npmjs.com/package/xlsx
            
            let arrList = [{name:'',abbrName:''},{name:'',abbrName:''}]
            const newData = [headerText, ...arrList];
            let fileName = '測試文件';

          
            let wb = { SheetNames: ['Sheet1'], Sheets: {}, Props: {} };

            //1.使用自定義表頭
            wb.Sheets['Sheet1'] = XLSX.utils.json_to_sheet(newData, { header: header, skipHeader: true });

            //2.使用表頭
           // wb.Sheets['Sheet1'] = XLSX.utils.json_to_sheet(arrList, { header: header });

            let out = XLSX.write(wb, {
              bookType: 'xlsx',
              bookSST: false,
              type: 'binary'
            });
            try {
              fileSaver.saveAs(new Blob([s2ab(out)], { type: 'application/octet-stream' }), fileName);
            } catch (e) {
              this.$message({
                type: 'error',
                message: '導(dǎo)出失敗'
              });
            }
          }

主要是多做嘗試，從文檔中查看解決方法。
查看配置：

圖片.png

圖片.png