vue XLSX 导出excel

导入组件 

import FileSaver from 'file-saver/dist/FileSaver.min'
import XLSX from 'xlsx'

 

methods

download() {
        let mapping = {
          office_name:'Office Name', // 字段名：‘label’
          user_name:'User Name',
          user_email:'Email',
          team_name:'Team',
          create_date:'Create Date',

        }
        let data = JSON.parse(JSON.stringify(this.tableDataIn));
        let out = [];
        for(let i =0;i<data.length;i++){
          let dd = data[i];
          let pp = {};
          for(let j in mapping){
            pp[mapping[j]] = dd[j]
          }
          out.push(pp)
        }
        var workBook = {
          SheetNames: ['Sheet1'],
          Sheets: {},
          Props: {}
        };
        workBook.Sheets['Sheet1'] = XLSX.utils.json_to_sheet(out)

        // var wb = XLSX.utils.json_to_sheet(this.filter_data);
        var wbout = XLSX.write(workBook, {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
      }