如何使用AJAX call & JavaScript将数据从数据库导出到Excel中？

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

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
  $(document).ready(function() {
    $('#exportBtn').click(function() {
      $.ajax({
        url: '/export-data', // 后端API的URL
        type: 'GET',
        success: function(response) {
          // 处理从后端返回的数据
          var excelData = response.data;

          // 生成Excel文件
          var workbook = XLSX.utils.book_new();
          var worksheet = XLSX.utils.json_to_sheet(excelData);
          XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
          var excelFile = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });

          // 下载Excel文件
          var blob = new Blob([excelFile], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
          var url = URL.createObjectURL(blob);
          var link = document.createElement('a');
          link.href = url;
          link.download = 'data.xlsx';
          link.click();
        },
        error: function(error) {
          console.log(error);
        }
      });
    });
  });
</script>

app.get('/export-data', function(req, res) {
  // 连接数据库，查询需要导出的数据
  // ...

  // 假设查询结果为excelData
  var excelData = [
    { name: 'John', age: 25 },
    { name: 'Jane', age: 30 },
    // ...
  ];

  res.json({ data: excelData });
});