Element导出Excel表格

安装

npm install xlsx file-saver -S
npm install script-loader -S -D

使用
this.dataLis表格的数据

 <el-button class="searchBtn" @click="excelExport()" type="primary">导出表格</el-button>

//点击导出
excelExport(){
  import('@/vendor/Export2Excel').then(excel => {
    const tHeader = ['用户名称', '账号', '手机号', '所属公司','用户角色','创建者','部门名称','创建时间','最近登录时间']
    const filterVal = ['userName', 'email', 'phonenumber', 'orgName','roleName','createBy','deptName','createTime','loginTime']
    const list = this.list
    const data = this.formatJson(filterVal, list)
    excel.export_json_to_excel({
      header: tHeader,
      data,
      filename: "账号列表",
      // filename: this.filename,
      autoWidth: this.autoWidth,
      bookType: this.bookType
    })
    this.downloadLoading = false
  })
},
formatJson(filterVal, jsonData) {
  return this.dataList.map(v => filterVal.map(j => {
    if (j === 'timestamp') {
      return parseTime(v[j])
    } else {
      return v[j]
    }
  }))
},

参数