vue中将开发的表格保存为excel的方法

参考了这篇博客https://blog.csdn.net/u010427666/article/details/79208145

一：cnpm install --save xlsx file-saver

npm install --save xlsx file-saver长时间没有相应，就换成了cnpm

二：导入这两个类

import FileSaver from 'file-saver'
import XLSX from 'xlsx'

exportExcel () {
    /* generate workbook object from table */
    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 {
        FileSaver.saveAs(new Blob([wbout], { type: 'application/octet-stream' }), 'sheetjs.xlsx')
    } catch (e) { if (typeof console !== 'undefined') console.log(e, wbout) }
    return wbout
}

三：在按钮的单击事件中调用exportExcel方法