将post数据从jQuery发送到phpexcel

$.ajax({
  url: 'your_php_file.php',
  type: 'POST',
  data: { key1: 'value1', key2: 'value2' },
  success: function(response) {
    console.log('Data sent successfully');
  },
  error: function(xhr, status, error) {
    console.log('Error: ' + error.message);
  }
});

<?php
// 接收POST数据
$data1 = $_POST['key1'];
$data2 = $_POST['key2'];

// 操作phpexcel库
require 'path_to_phpexcel_library/PHPExcel.php';

$objPHPExcel = new PHPExcel();
$objPHPExcel->getActiveSheet()->setCellValue('A1', $data1);
$objPHPExcel->getActiveSheet()->setCellValue('B1', $data2);

// 保存Excel文件
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('path_to_save_excel_file/excel_file.xlsx');

echo 'Data saved to Excel file';
?>