<el-button @click="downloadTemplate" type="primary">模版</el-button>
<!-- 表单展示区 -->
<el-table
id='table'
:data="tableData"
border
style="width:100%;display:none;"
>
<el-table-column prop="name" label="设备名称"></el-table-column>
<el-table-column prop="code" label="设备编号"></el-table-column>
<el-table-column prop="type" label="设备类型"></el-table-column>
<el-table-column prop="unitId" label="网关编号"></el-table-column>
<el-table-column prop="gatewayId" label="是否为重大火灾危险源设备"></el-table-column>
<el-table-column prop="gatewayId1" label="位置描述(非必填)"></el-table-column>
</el-table>
import XLSX from"xlsx";
// 下载模板
downloadTemplate(){
var vm=this
var wb = XLSX.utils.table_to_book(document.querySelector("#table"));
var wbout = XLSX.write(wb, {
bookType: "xlsx",
bookSST: true,
type: "array"
});
try {
FileSaver.saveAs(
new Blob([wbout], { type: "application/octet-stream" }),
'设备导入模板' + ".xlsx"
);
vm.dialogVisible=false
} catch (e) {
if (typeof console !== "undefined") console.log(e, wbout);
}
console.log(wbout)
return wbout;
},
效果