使用
npm install file-saver --save
bower install file-saver
在瀏覽器上能夠把table生成excel表，但是不能下載，生成后直接傳給后臺，咋來？？？？？？？
export2Excel() {
let tables = document.getElementById("out-table");
let table_book = this.$XLSX.utils.table_to_book(tables);
var table_write = this.$XLSX.write(table_book, {
bookType: "xlsx",
bookSST: true,
type: "array"
});
try {
let userAgent = navigator.userAgent;
//兼容ie瀏覽器
if (userAgent.indexOf('Trident') !== -1 && userAgent.indexOf('Windows') !== -1) {
let blob = new Blob([table_write], {type: 'application/octet-stream'});
console.log(blob);
this.$FileSaver.saveAs(blob, "sheetjs.xlsx");
} else { //兼容谷歌 火狐
let file = new File([table_write], "sheetjs.xlsx", {type: "application/octet-stream"});
console.log(file);
this.$FileSaver.saveAs(file);
}
} catch (e) {
if (typeof console !== "undefined") console.log(e, table_write);
}
return table_write;
},
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/245473.html
標籤：跨瀏覽器開發
上一篇：新人求助！！跳轉鏈接怎么進行保護
下一篇：求助，代寫作業的群！！！