Laravel 8生产环境（Windows Server）无法缓存PHPSpreadsheet对象求助

• 核心原因：PHPSpreadsheet的Spreadsheet对象可能包含无法序列化的资源（如文件句柄）或循环引用，而Laravel的file缓存驱动依赖PHP的serialize()函数，这类对象无法被正常序列化存储。

• 解决方案1：将对象转为字节流缓存
  把Spreadsheet对象转为Excel格式的字节流，缓存字节流后再反向恢复：

  // 缓存Spreadsheet对象
  $writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx');
  ob_start();
  $writer->save('php://output');
  $spreadsheetData = ob_get_clean();
  Cache::put($cacheKey, $spreadsheetData, now()->addMinutes(2));
  
  // 从缓存恢复Spreadsheet对象
  $spreadsheetData = Cache::get($cacheKey);
  $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($spreadsheetData);
  

• 解决方案2：缓存必要数据而非整个对象
  如果仅需使用对象中的数据，可提取核心数据到数组缓存，需要时重建对象：

  // 提取工作表数据到数组
  $data = [];
  foreach ($spreadsheet->getAllSheets() as $sheet) {
      $data[$sheet->getTitle()] = $sheet->toArray();
  }
  Cache::put($cacheKey, $data, now()->addMinutes(2));
  
  // 从数组重建Spreadsheet对象
  $data = Cache::get($cacheKey);
  $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
  foreach ($data as $sheetTitle => $rows) {
      $sheet = $spreadsheet->createSheet();
      $sheet->setTitle($sheetTitle);
      foreach ($rows as $rowIndex => $row) {
          foreach ($row as $colIndex => $value) {
              $sheet->setCellValueByColumnAndRow($colIndex+1, $rowIndex+1, $value);
          }
      }
  }
  

• 验证序列化问题
  手动测试对象是否可序列化，排查具体错误：

  try {
      serialize($spreadsheet);
      echo "对象可序列化";
  } catch (\Throwable $e) {
      echo "序列化失败：" . $e->getMessage();
  }
  

内容的提问来源于stack exchange，提问作者owf