乐趣区

关于vue.js:elementadmin-自定义二级表头表格导出数据

` // 导出 excel

  const length = this.columnOptions.length - 1;// 一级表头的长度
  let sHeader = [];
  let h1 = []; // 类别项
  for (let i = 0; i < this.tableHeader.length; i++) {let arr = [];
    if (length == 5 || this.homeData.type == 999) {arr = [this.tableHeader[i].typeValueName, '','', ''];
    } else {arr = [this.tableHeader[i].typeValueName, '',''];
    } 
    h1 = h1.concat(arr);
    sHeader = this.tableItem.map(h => h.label).concat(sHeader);
  }
  const header = Array(length).fill('').concat(sHeader);// 二级表内容
  const fHeader = this.columnOptions.filter(h => h.label).map(i => i.label);
  const multiHeader = [fHeader.concat(h1)]; // 多级表头
  const data = [];// 传入的数据
  const filterVal = this.columnOptions.filter(p => p.prop).map(i => i.prop); // 表头名
  for (let i = 0; i < this.listData.length; i++) {const data1 = [].concat.apply([], this.formatJson(this.tableItem.map(h => h.prop), this.listData[i].customReportPoList));// 二级表数据
    data[i] = this.formatJson(filterVal, this.listData)[i].concat(data1);
  }
  console.log(data, 'data');
  // 合并 excel 中的列
  const merges = [];
  for (var i = 0; i < length; i++) {const p = `${String.fromCharCode((65 + i))}1:${String.fromCharCode((65 + i))}2`;
    merges.push(p);
  }
  let p1 = '';
  for (let k = 0; k < (data[0].length - length) / this.tableItem.length; k++) {
    let m = length;
    m = m + k * this.tableItem.length;
    p1 = `${m < 26 ? String.fromCharCode((65 + m)) : (m - 26 < 26) ? 'A' + String.fromCharCode((65 + m - 26)) : 'B' + String.fromCharCode((65 + m - 52))}1:${m + this.tableItem.length - 1 < 26 ? String.fromCharCode((65 + m + this.tableItem.length - 1)) : (m - 26 + this.tableItem.length - 1 < 26) ? 'A' + String.fromCharCode((65 + m - 26 + this.tableItem.length - 1)) : 'B' + String.fromCharCode((65 + m - 52 + this.tableItem.length))}1`;
    merges.push(p1);
  }
  import('@/vendor/Export2Excel').then(excel => {
    excel.export_json_to_excel({
      multiHeader,
      header,
      data,
      merges,
      filename: this.title
    });`
退出移动版