您可以将范围转换为表：

const sheet = context.workbook.worksheets.getItem("Sample");
let expensesTable = sheet.tables.add("A1:E7", true);
expensesTable.name = "ExpensesTable";

这里是示例要点，您可以尝试https://gist.github.com/lumine2008/8eccb88f7fccf34b63c7ecd5fd05aaea

来源：表格允许表格数据的表内操作。

import * as exceljs from 'exceljs';

const workbook = new exceljs.Workbook();
const worksheet = workbook.addWorksheet('William');

// add a table to a sheet
worksheet.addTable({
  name: 'Dam',
  ref: 'A1',
  headerRow: true,
  totalsRow: true,
  style: {
    theme: 'TableStyleDark3',
    showRowStripes: true,
  },
  columns: [
    {name: 'Date', totalsRowLabel: 'Totals:', filterButton: true},
    {name: 'Amount', totalsRowFunction: 'sum', filterButton: false},
  ],
  rows: [
    [new Date('2019-07-20'), 70.10],
    [new Date('2019-07-21'), 70.60],
    [new Date('2019-07-22'), 70.10],
  ],
});