使用ReactJs jQuery ajax post请求下载时Excel文件损坏

import $ from 'jquery';

function downloadExcel() {
  $.ajax({
    url: '/download',
    method: 'POST',
    xhrFields: {
      responseType: 'blob' // 指定响应类型为二进制数据
    },
    success: function(response) {
      const blob = new Blob([response]);
      const downloadUrl = URL.createObjectURL(blob);
      const a = document.createElement('a');
      a.href = downloadUrl;
      a.download = 'example.xlsx'; // 指定文件名
      document.body.appendChild(a);
      a.click();
      document.body.removeChild(a);
      URL.revokeObjectURL(downloadUrl);
    }
  });
}

// 调用下载函数
downloadExcel();

const express = require('express');
const app = express();
const xlsx = require('xlsx'); // 用于生成Excel文件

app.post('/download', (req, res) => {
  const data = [
    ['姓名', '年龄'],
    ['张三', 25],
    ['李四', 30],
    ['王五', 28]
  ];

  const worksheet = xlsx.utils.aoa_to_sheet(data);
  const workbook = xlsx.utils.book_new();
  xlsx.utils.book_append_sheet(workbook, worksheet, 'Sheet1');

  const excelBuffer = xlsx.write(workbook, { type: 'buffer', bookType: 'xlsx' });

  res.set({
    'Content-Type': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
    'Content-Disposition': 'attachment; filename="example.xlsx"'
  });

  res.send(excelBuffer);
});

// 启动服务器
app.listen(3000, () => {
  console.log('服务器已启动');
});