如何在node js中写入xls文件和响应流

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

const app = express();

app.get('/download', (req, res) => {
  // 创建一个新的工作簿
  const workbook = new ExcelJS.Workbook();
  const worksheet = workbook.addWorksheet('Sheet 1');

  // 添加数据到工作表
  worksheet.addRow(['Name', 'Age']);
  worksheet.addRow(['John', 25]);
  worksheet.addRow(['Jane', 30]);

  // 设置响应头，告诉浏览器下载文件
  res.setHeader('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  res.setHeader('Content-Disposition', 'attachment; filename="data.xlsx"');

  // 将工作簿写入响应流
  workbook.xlsx.write(res)
    .then(() => {
      res.end();
    })
    .catch((error) => {
      console.log(error);
      res.status(500).send('Internal Server Error');
    });
});

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

npm install express exceljs