1.引入2個(gè)必要的包

npm i xlsx file-saver -S

2.在需要導(dǎo)出表格的位置，引入這2個(gè)包

import FileSaver from "file-saver"
import XLSX from "xlsx"

3.對(duì)el-table加上id屬性，注：作者試了ref，不能用

<el-table
     id="mytable"
     :data="userData"
     border>

4.設(shè)置導(dǎo)出的事件行為

 <el-button @click="output" >導(dǎo)出</el-button>

5.寫output方法，直接復(fù)制就行了

output(){
        var wb = XLSX.utils.table_to_book(document.querySelector("#mytable"));//mytable為表格的id名
        /* 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" }),
            "sheet1.xlsx"http://導(dǎo)出的表名
          );
        } catch (e) {
          if (typeof console !== "undefined") console.log(e, wbout);
        }
        return wbout;
      }