如何在Angular 7中用“exceljs”定制(样式) excel文件

npm install exceljs --save

import * as ExcelJS from 'exceljs/dist/exceljs.min.js';
import * as fs from 'file-saver';

const workbook = new ExcelJS.Workbook();

const worksheet = workbook.addWorksheet('Sheet1');

const headerStyle = {
  font: { bold: true },
  fill: { type: 'pattern', pattern: 'solid', fgColor: { argb: 'FFFF0000' } },
  border: { top: { style: 'thin' }, left: { style: 'thin' }, bottom: { style: 'thin' }, right: { style: 'thin' } }
};

const cellStyle = {
  border: { top: { style: 'thin' }, left: { style: 'thin' }, bottom: { style: 'thin' }, right: { style: 'thin' } }
};

// 添加表头
worksheet.addRow(['Column 1', 'Column 2', 'Column 3']);
worksheet.getRow(1).eachCell((cell) => {
  cell.fill = headerStyle.fill;
  cell.font = headerStyle.font;
  cell.border = headerStyle.border;
});

// 添加数据
worksheet.addRow(['Data 1', 'Data 2', 'Data 3']);
worksheet.getRow(2).eachCell((cell) => {
  cell.border = cellStyle.border;
});

workbook.xlsx.writeBuffer().then((buffer) => {
  const blob = new Blob([buffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
  fs.saveAs(blob, 'example.xlsx');
});