Laravel phpspreadsheet使用ajax传递数据

$.ajax({
  url: '/process-data',
  method: 'POST',
  data: { 
    // 传递的数据
    data1: 'value1',
    data2: 'value2'
  },
  success: function(response) {
    // 请求成功后的处理
    console.log(response);
  },
  error: function(error) {
    // 请求失败时的处理
    console.log(error);
  }
});

Route::post('/process-data', 'DataController@processData');

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

public function processData(Request $request) {
  // 获取传递的数据
  $data1 = $request->input('data1');
  $data2 = $request->input('data2');
  
  // 使用phpspreadsheet处理数据
  $spreadsheet = new Spreadsheet();
  $sheet = $spreadsheet->getActiveSheet();
  $sheet->setCellValue('A1', $data1);
  $sheet->setCellValue('A2', $data2);
  
  $writer = new Xlsx($spreadsheet);
  $writer->save('example.xlsx');
  
  // 返回处理结果
  return response()->json(['message' => 'Data processed successfully']);
}