在Noe JS中无法下载Excel文件

const fs = require('fs');
const XLSX = require('xlsx');
const express = require('express');
const app = express();

app.get('/download', (req, res) => {
  const wb = XLSX.utils.book_new();
  const ws = XLSX.utils.aoa_to_sheet([
    ['Name', 'Age'],
    ['John', 25],
    ['Jane', 30],
  ]);
  XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
  const excelFilePath = 'path/to/excel.xlsx';

  // 生成Excel文件
  XLSX.writeFile(wb, excelFilePath);

  // 读取Excel文件流
  const stream = fs.createReadStream(excelFilePath);
  const stats = fs.statSync(excelFilePath);

  // 设置响应头
  res.setHeader('Content-disposition', 'attachment; filename=excel.xlsx');
  res.setHeader('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  res.setHeader('Content-Length', stats.size);

  // 将文件流发送给客户端
  stream.pipe(res);
});

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

const XLSX = require('xlsx');

// 生成Excel文件
const wb = XLSX.utils.book_new();
const ws = XLSX.utils.aoa_to_sheet([
  ['Name', 'Age'],
  ['John', 25],
  ['Jane', 30],
]);
XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
const excelBuffer = XLSX.write(wb, { type: 'buffer', bookType: 'xlsx' });

// 将Excel文件转换为Blob对象
const blob = new Blob([excelBuffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });

// 创建下载链接
const downloadUrl = URL.createObjectURL(blob);

// 创建<a>标签并设置下载链接
const downloadLink = document.createElement('a');
downloadLink.href = downloadUrl;
downloadLink.download = 'excel.xlsx';

// 模拟点击下载
downloadLink.click();