vue 导出表格为xlsx文件（简易版）

vue 导出表格为xlsx文件（简易版）

1、先安装xlsx和file-saver

cnpm install --save xlsx file-saver

2、Script部分

import FileSaver from "file-saver";
import XLSX from "xlsx";
exportexcel() {//设置当前日期let time = new Date();let year = FullYear();let month = Month() + 1;let day = Date();let name = year + "" + month + "" + day;//console.log(name)//选择要导出的表格var wb = XLSX.utils.table_to_book(document.querySelector(".table"));//console.log(wb)/* get binary string as output */var wbout = XLSX.write(wb, {bookType: "xlsx",bookSST: true,type: "array"});//console.log(wbout)try {//  name+'.xlsx'表示导出的excel表格名字FileSaver.saveAs(new Blob([wbout], { type: "application/octet-stream" }),name + ".xlsx");} catch (e) {if (typeof console !== "undefined") console.log(e, wbout);}return wbout;},