vue 插件导出excel

 导入

npm install --save xlsx file-saver

 使用方式 exportExcel（“表格的id”,'''导出excel的文件名'）

exportExcel.js

import FileSaver from 'file-saver'
import XLSX from 'xlsx'
export default {
	exportExcel(id,title) {
		var xlsxParam = {
			raw: true
		}
		var wb = XLSX.utils.table_to_book(
			document.querySelector('#' +id),
			xlsxParam
		)
		var wbout = XLSX.write(wb, {
			bookType: 'xlsx',
			bookSST: true,
			type: 'array'
		})
		try {
			FileSaver.saveAs(
				new Blob([wbout], {
					type: 'application/octet-stream'
				}),
				title + '.xlsx'
			)
		} catch (e) {
			if (typeof console !== 'undefined') console.log(e, wbout)
		}
		return wbout
	}
}