前端直接导出excel

1.安装插件

yarn add xlsx file-saver

2.在导出的事件中

exportExcel(){
	let et = XLSX.utils.table_to_book(
	//获取table的DOM
        document.getElementById("table-contents")
      );
      let etout = XLSX.write(et, {
        bookType: "xlsx",
        bookSST: true,
        type: "array"
      });

      try {
        FileSaver.saveAs(
          new Blob([etout], {
            type: "application/octet-stream"
          }),
          "XXX.xls"
        );
      } catch (e) {
        //console.log(e, etout)
      }
      console.log(etout);
      return etout;
}