vue超简单导出表格数据

此项目采用的组件库是elementUI

1.添加一个点击事件

<el-button @click="outTab">导出数据</el-button>

2.调用方法，#out-table是表格的id

代码

outTab () {
      /* generate workbook object from table */
      let wb = XLSX.utils.table_to_book(document.querySelector('#out-table'))
      /* get binary string as output */
      let 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
    },

3.点击一下导出数据按钮，表格就开始下载啦