前端导出XLSX.等格式文件

使用前端导出表格为xlsx格式文件并下载到本地

npm install file-saver
npm install XLSX

公共方法：
import FileSaver from ‘file-saver’;
import XLSX from ‘xlsx’;

export const htmlToExcel = {
getexcel(dom,title=‘默认标题’){
var excelTitle=title //获取标题
var wb = XLSX.utils.table_to_book(document.querySelector(dom)) //获取元素
var wbout = XLSX.write(wb,{bookType:‘xlsx’,bookSST:true,type:‘array’})
try {
FileSaver.saveAs(
new Blob([wbout], { type: “application/octet-stream” }),
excelTitle + “.xlsx”
);
} catch (e) {
if (typeof console !== “undefined”) console.log(e, wbout);
}
return wbout;
wbout = []
}
};

export default htmlToExcel;