XLSX 导出excel文件 (TS)

Step 1. 安装依赖 xlsx

yarn add xlsx

Step 2. Import

import * as XLSX from 'xlsx';

Step 3. Usage

xlsx支持多种格式导出，具体可以参考官方文档github

demo

class Export {
  private _wb: XLSX.WorkBook = XLSX.utils.book_new();

  appendSheet(aoaData, {
    sheetName = 'sheet',
  } = {}) {
    // 与左上角和右下角确认一个矩形相似
    const merge = {
      // start
      s: {
        // row
        r: 0,
        // column
        c: 0
      },
      // end
      e: {
        r: 0,
        c: 1,
      }
    };
    // 与以下写法结果相同
    // const merge = XLSX.utils.decode_range("A1:A2");

    const ws: XLSX.WorkSheet = XLSX.utils.aoa_to_sheet(aoaData);

    if (!ws['!merges']) {
       ws['!merges'] = [];
    }
    ws['!merges'].push(merge);

    XLSX.utils.book_append_sheet(this._wb, ws, sheetName);
  }

  exportExcelFile(filename = 'export.xlsx') {
    XLSX.writeFile(this._wb, filename);
  }
}

let exports = new Export();

exports.appendSheet([['a', 'b'], ['c'], ['d', 'e', 'f']]);

exports.exportExcelFile();

Refs

js-xlsx
merge cells from Array of Arrays

赏

谢谢老板~(≧▽≦)/~

支付宝

微信