nodejs中的exceljs excel表格中未填写合计数据

const ExcelJS = require('exceljs');

let workbook = new ExcelJS.Workbook();
workbook.xlsx.readFile('example.xlsx')
  .then(() => {
    let worksheet = workbook.getWorksheet(1);
    // 检查数据源
    worksheet.eachRow((row, rowNumber) => {
      console.log(`Row ${rowNumber}: ${JSON.stringify(row.values)}`);
    });
  })
  .catch(err => console.error(err));

// 假设我们要计算某一列的合计值
let total = 0;
worksheet.eachRow((row, rowNumber) => {
  if (rowNumber > 1) { // 跳过标题行
    let cellValue = row.getCell('B').value;
    if (cellValue !== undefined && cellValue !== null && !isNaN(cellValue)) {
      total += cellValue;
    }
  }
});

// 将合计值写入新的单元格
worksheet.addRow([null, null, `Total: ${total}`]);

try {
  // 数据处理代码
} catch (error) {
  console.error('An error occurred:', error);
}