FileSaver+xlsx 表格下载为excel

安装依赖形式，参考 vue+elementUI 表格下载为excel

1. 下载地址

FileSaver.js
SheetJS js-xlsx

下载后，分别从 dist 文件夹下复制出以下两个文件，放在相应目录下

1.引入js

<script lang="javascript" src="js/xlsx.full.min.js"></script>
<script src="js/FileSaver.min.js" charset="utf-8"></script>

2.添加方法

exportData() {
	var xlsxParam = { raw: true };
	var wb = XLSX.utils.table_to_book(document.querySelector('#exportable'),xlsxParam);
	var wbout = XLSX.write(wb, { bookType: 'xlsx', bookSST: true, type: 'array' })
	try {
		saveAs(new Blob([wbout], { type: 'application/octet-stream' }), '薪资明细.xlsx')
	} catch (e) { if (typeof console !== 'undefined') console.log(e, wbout) }
	return wbout
},

3.添加id

<el-table id="exportable" ref="table" :height="tableHeight" highlight-current-row  v-loading="loading" :data="tableData" >