vueJs导出excel文件

一、安装依赖

cnpm install --save xlsx file-saver

二、导入依赖包

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

三、添加导出按钮

<el-form-item>
   <el-button @click="exportExcel" style="margin-top: 2px;" size="small" type="success">导出</el-button>
</el-form-item>

<el-table :data="data" highlight-current-row @selection-change="selsChange"
                style="width: 100%;" id="rebateSetTable" > </el-table>

四、方法实现

exportExcel:function() {
        let wb = XLSX.utils.table_to_book(document.querySelector('#rebateSetTable'));
        let wbout = XLSX.write(wb, { bookType: 'xlsx', bookSST: true, type: 'array' });
        try {
            FileSaver.saveAs(new Blob([wbout], { type: 'application/octet-stream' }), '商会列表.xlsx');
        } catch (e) {
            if (typeof console !== 'undefined')
                console.log(e, wbout)
        }
        return wbout
      },