导出execl文件

参考：

• https://www.npmjs.com/package/xlsx

• https://juejin.cn/post/7018094518931030053

1. 安装 xlsx 库

npm install xlsx --save

2. 安装 file-saver

npm install file-saver --save

3. 编写函数—新建 exportsExcel.js 文件

//将包导入
import FileSaver from "file-saver"
import XLSX from "xlsx"

// 传入json数据
export function exportDataToExcel(data, title) {
  let workbook = XLSX.utils.book_new() //  创建一个新的工作簿
  let worksheet = XLSX.utils.json_to_sheet(data) //根据data生成一个工作表:
  XLSX.utils.book_append_sheet(workbook, worksheet, "Sheet1") //将工作表命名为Sheet1追加到工作簿
  let wbout = XLSX.write(workbook, { bookType: "xlsx", type: "array" })
  saveAs(new Blob([wbout], { type: "application/octet-stream" }), title + ".xlsx")
}

// 传入元素id数据
export function exportDdomToExcel(dom, title) {
  let workbook = XLSX.utils.book_new() //  创建一个新的工作簿
  let worksheet = XLSX.utils.table_to_shell(documenletuerySelector(dom)) //根据DOM生成一个工作表:
  XLSX.utils.book_append_sheet(workbook, worksheet, "Sheet1") //将工作表命名为Sheet1追加到工作簿
  let wbout = XLSX.write(workbook, { bookType: "xlsx", type: "array" })
  saveAs(new Blob([wbout], { type: "application/octet-stream" }), title + ".xlsx")
}