前端导出excel

插件：js-export-excel

const ExportJsonExcel = require('js-export-excel');
/**
 * @description: 导出excel
 * @param {*} name 导出文件名
 * @param {*} data 数据
 * @param {*} header 表头数组
 * @return {*}
 */
export function downLoad(name, data, header) {
  const data_ = data ? data : '';
  let option = {};
  let dataTable = [];
  dataTable = formatData(data_, header);
  let colW = new Array(header.length).fill(10);
  option.fileName = name;
  option.datas = [
    {
      sheetData: dataTable, //表格数据
      sheetHeader: header, //配置表头
      columnWidths: colW //列宽
    }
  ];
  let toExcel = new ExportJsonExcel(option);
  toExcel.saveExcel();
}

/**
 * @description: 删除表头中不存在的字段
 * @param {*} data_ 表格数据
 * @param {*} header 表头
 * @return {*}
 */
const formatData = (data_, header) => {
  let dataTable = [];
  data_.map(item => {
    for (let i in item) {
      if (
        !header.some(item => {
          return item == i;
        })
      )
        delete item[i];
    }
    dataTable.push(item);
  });
  return dataTable;
};