vue 实现表格导出excel表

npm install -S file-saver xlsx

npm install -D script-loader

exportOrderExcelHandler() {
  require.ensure([], () => {
   const {export_json_to_excel} = require(‘@/utils/Export2Excel‘)
   const tHeader = ["订单号","任务名称","文件名称","url"] //这是要导出excel表的表头
   const filterVal = ["orderNo","taskName","fileName","url"] //这里的每一项是要导出 表单数据的key值；
   const list = this.testList； //要导出的数据
   const data = this.formatJson(filterVal, list);
   const name = "要导出的订单"; //要导出的订单的名字
   export_json_to_excel(tHeader, data, name)
  })
  },
  formatJson(filterVal, jsonData) {
  return jsonData.map(v => filterVal.map(j => v[j]))
  }