单击按钮将错误的DataTable提取到Excel中

<button id="exportBtn">导出到Excel</button>

const express = require('express');
const app = express();
const ExcelJS = require('exceljs');

app.get('/export', (req, res) => {
  // 模拟错误的DataTable数据
  const dataTable = [
    { id: 1, name: 'John', error: 'NullPointerException' },
    { id: 2, name: 'Jane', error: 'ArrayIndexOutOfBoundsException' },
    { id: 3, name: 'Bob', error: 'DivideByZeroException' }
  ];

  // 创建Excel工作簿
  const workbook = new ExcelJS.Workbook();
  const worksheet = workbook.addWorksheet('Errors');

  // 设置表头
  worksheet.columns = [
    { header: 'ID', key: 'id', width: 10 },
    { header: 'Name', key: 'name', width: 20 },
    { header: 'Error', key: 'error', width: 30 }
  ];

  // 填充数据
  dataTable.forEach(data => {
    worksheet.addRow(data);
  });

  // 导出Excel文件
  res.setHeader('Content-Disposition', 'attachment; filename="errors.xlsx"');
  res.setHeader('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  workbook.xlsx.write(res).then(() => {
    res.end();
  });
});

app.listen(3000, () => {
  console.log('Server is running on port 3000');
});