vue 前端导出excel

import ExportJsonExcel from "js-export-excel"

export function downloadExcel (fileName,exportData,columns) {
  const option = {};
  let dataTable = [];
  for (let i in exportData) {
    const result = {};
    for (let i in columns) {
      if (i != 0){
        result[columns[i].dataIndex] = exportData[i][columns[i].dataIndex];
      }
    }
    dataTable.push(result)
  }
  var filterList = new Array;
  var headerList = new Array;
  for (let i in columns) {
    if (i != 0){
      filterList.push(columns[i].dataIndex);
      headerList.push(columns[i].title);
    }
  }

  option.fileName = fileName;
  option.datas = [
    {
      sheetData:dataTable,
      sheetName: fileName,     // Excel文件名称
      sheetFilter: filterList,
      sheetHeader: headerList
    },
  ];
  const toExcel = new ExportJsonExcel(option);
  toExcel.saveExcel();
}

调用：
downloadExcel(fileName){
        import(‘@/utils/jsExportExcel‘).then(excel => {
          excel.downloadExcel(fileName, this.dataSource, this.columns)
        })
      },