vue导出excel功能

1.安装依赖包
参考网址：https://cloud.tencent.com/developer/article/1394081

npm install -S file-saver xlsx
npm install -D script-loader

2.代码如下
//el-button标签

 <el-button  @click="exportExcel"     type="primary"    \>导出</el-button\>

//表格注意id

<el-table

​    id="out-table"

​    :key="tableKey"

​    :data="list"

​    :height="tableH"

​    border

​    fit

​    stripe="true"

​    style="width: 100%"

​    :header-cell-style="{ 'background-color': '#FAFAFA' }"

   \>

//import file-saver和xlsx

import FileSaver from "file-saver";

import XLSX from "xlsx";

//导出excel方法注意#

 exportExcel() {

   var wb = XLSX.utils.table_to_book(document.querySelector("#out-table"));

   /* get binary string as output */

   var wbout = XLSX.write(wb, {

​    bookType: "xlsx",

​    bookSST: true,

​    type: "array",

   });

   try {

​    FileSaver.saveAs(

​     new Blob([wbout], { type: "application/octet-stream" }),

​     "葵花宝典.xlsx"

​    );

   } catch (e) {

​    if (typeof console !== "undefined") console.log(e, wbout);

   }

   return wbout;

  },

 },

};