需要安装俩个插件
npm install --save xlsx file-saver
<el-table :data="tableData" style="width: 100%">
<el-table-column prop="num" label="订单号" width="126">
<template slot-scope="scope">
<p class="f14 c6 single">{{ scope.row.num }}</p>
</template>
</el-table-column>
<el-table-column prop="add" label="被打赏人"></el-table-column>
<el-table-column prop="type" label="订单完成时间"></el-table-column>
<el-table-column prop="pl" label="客户端渠道"></el-table-column>
<el-table-column prop="add" label="打赏用户昵称"></el-table-column>
<el-table-column prop="mo" label="订单总价"></el-table-column>
<el-table-column prop="mo" label="获得收益"></el-table-column>
</el-table>
在使用的组件内引入
import FileSaver from “file-saver”;
import XLSX from “xlsx”
// 导出表格
exportExcel() {
console.log("导出表格")
// 设置当前日期
let time = new Date();
let year = time.getFullYear();
let month = time.getMonth() + 1;
let day = time.getDate();
let name = year + "" + month + "" + day;
// .table要导出的是哪一个表格,我通过this.$refs没获取到,不过用原生获取节点也一样
var wb = XLSX.utils.table_to_book(document.querySelector(".table"));
/* get binary string as output */
var wbout = XLSX.write(wb, {
bookType: "xlsx",
bookSST: true,
type: "array"
});
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;
}