angular+excelJs结合file-saver

exceljs文档

FileSaver文档（用于保存文件下载）

// 前端excel模板示例

import * as ExcelJS from 'exceljs';
import * as fs from 'file-saver';

  async exportExcel() {
    const workbook = new ExcelJS.Workbook();
    const worksheet = workbook.addWorksheet('My Sheet',
      {
        properties: {
          tabColor: { argb: 'ff0000' },
          defaultColWidth: 20,
          defaultRowHeight: 20,
        }, views: [{ state: 'frozen', xSplit: 1, ySplit: 1 }]
      });

    // 设置列
     worksheet.columns = [
       { header: 'Id', key: 'id', },
       { header: 'Name', key: 'name', },
       { header: 'D.O.B.', key: 'DOB', }
     ];

    let tableDate = [{ id: 1, name: 'John Doe', DOB: '2022-06-18' }, { id: 2, name: 'Jane Doe', DOB: '2022-06-18' }];

   // worksheet.columns = this.excelSheet;
    // 插入数据
    worksheet.addRows(tableDate);

    // 写入文件
    const buffer = await workbook.xlsx.writeBuffer();
    fs.saveAs(new Blob([buffer], {
      type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', // 示例时可去掉type
    }), `Equity Risk Rating - ${DateFormatter.simpleDateFormatter(new Date())}.xlsx`)

  }