这个问题在这里已有答案：
我使用phpexcel导出文件xlsx，数据有32列和多行 . 每天数据都会增加，因此数据会非常大 . 这是我的代码：
$filename="data.xlsx";
$cacheMethod = PHPExcel_CachedObjectStorageFactory:: cache_to_phpTemp;
$cacheSettings = array( 'memoryCacheSize' => '128MB');
PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);
ini_set('max_execution_time', 123456);
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
$i = 2;
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Header1');
$objPHPExcel->getActiveSheet()->setCellValue('B1', 'Header2');
$objPHPExcel->getActiveSheet()->setCellValue('C1', 'Header3');
$objPHPExcel->getActiveSheet()->setCellValue('D1', 'Header4');
$objPHPExcel->getActiveSheet()->setCellValue('E1', 'Header5');
$objPHPExcel->getActiveSheet()->setCellValue('F1', 'Header6');
$objPHPExcel->getActiveSheet()->setCellValue('G1', 'Header7');
$objPHPExcel->getActiveSheet()->setCellValue('H1', 'Header8');
$objPHPExcel->getActiveSheet()->setCellValue('I1', 'Header9');
$objPHPExcel->getActiveSheet()->setCellValue('J1', 'Header10');
$objPHPExcel->getActiveSheet()->setCellValue('K1', 'Header11');
$objPHPExcel->getActiveSheet()->setCellValue('L1', 'Header12');
$objPHPExcel->getActiveSheet()->setCellValue('M1', 'Header13');
$objPHPExcel->getActiveSheet()->setCellValue('N1', 'Header14');
$objPHPExcel->getActiveSheet()->setCellValue('O1', 'Header15');
$objPHPExcel->getActiveSheet()->setCellValue('P1', 'Header16');
$objPHPExcel->getActiveSheet()->setCellValue('Q1', 'Header17');
$objPHPExcel->getActiveSheet()->setCellValue('R1', 'Header18');
$objPHPExcel->getActiveSheet()->setCellValue('S1', 'Header19');
$objPHPExcel->getActiveSheet()->setCellValue('T1', 'Header20');
$objPHPExcel->getActiveSheet()->setCellValue('U1', 'Header21');
$objPHPExcel->getActiveSheet()->setCellValue('V1', 'Header22');
$objPHPExcel->getActiveSheet()->setCellValue('W1', 'Header23');
$objPHPExcel->getActiveSheet()->setCellValue('X1', 'Header24');
$objPHPExcel->getActiveSheet()->setCellValue('Y1', 'Header25');
$objPHPExcel->getActiveSheet()->setCellValue('Z1', 'Header26');
$objPHPExcel->getActiveSheet()->setCellValue('AA1', 'Header27');
$objPHPExcel->getActiveSheet()->setCellValue('AB1', 'Header28');
$objPHPExcel->getActiveSheet()->setCellValue('AC1', 'Header29');
$objPHPExcel->getActiveSheet()->setCellValue('AD1', 'Header30');
$objPHPExcel->getActiveSheet()->setCellValue('AE1', 'Header31');
$objPHPExcel->getActiveSheet()->setCellValue('AF1', 'Header32');
foreach ($data as $value) {
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $value['1']);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $value['2']);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $value['3']);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $value['4']);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $value['5']);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $value['6']);
$objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $value['7']);
$objPHPExcel->getActiveSheet()->setCellValue('H'.$i, $value['8']);
$objPHPExcel->getActiveSheet()->setCellValue('I'.$i, $value['9']);
$objPHPExcel->getActiveSheet()->setCellValue('J'.$i, $value['10']);
$objPHPExcel->getActiveSheet()->setCellValue('K'.$i, $value['11']);
$objPHPExcel->getActiveSheet()->setCellValue('L'.$i, $value['12']);
$objPHPExcel->getActiveSheet()->setCellValue('M'.$i, $value['13']);
$objPHPExcel->getActiveSheet()->setCellValue('N'.$i, $value['14']);
$objPHPExcel->getActiveSheet()->setCellValue('O'.$i, $value['15']);
$objPHPExcel->getActiveSheet()->setCellValue('P'.$i, $value['16']);
$objPHPExcel->getActiveSheet()->setCellValue('Q'.$i, $value['17');
$objPHPExcel->getActiveSheet()->setCellValue('R'.$i, $value['18']);
$objPHPExcel->getActiveSheet()->setCellValue('S'.$i, $value['19']);
$objPHPExcel->getActiveSheet()->setCellValue('T'.$i, $value['20']);
$objPHPExcel->getActiveSheet()->setCellValue('U'.$i, $value['21']);
$objPHPExcel->getActiveSheet()->setCellValue('V'.$i, $value['22']);
$objPHPExcel->getActiveSheet()->setCellValue('W'.$i, $value['23']);
$objPHPExcel->getActiveSheet()->setCellValue('X'.$i, $value['24']);
$objPHPExcel->getActiveSheet()->setCellValue('Y'.$i, $value['25']);
$objPHPExcel->getActiveSheet()->setCellValue('Z'.$i, $value['26']);
$objPHPExcel->getActiveSheet()->setCellValue('AA'.$i, $value['27']);
$objPHPExcel->getActiveSheet()->setCellValue('AB'.$i, $value['28']);
$objPHPExcel->getActiveSheet()->setCellValue('AC'.$i, $value['29']);
$objPHPExcel->getActiveSheet()->setCellValue('AD'.$i, $value['30']);
$objPHPExcel->getActiveSheet()->setCellValue('AE'.$i, $value['31']);
$objPHPExcel->getActiveSheet()->setCellValue('AF'.$i, $value['32']);
$i++;
}
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
ob_end_clean();
header("Content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
header("Content-Disposition: attachment; filename=".$filename);
header('Cache-Control: max-age=0');
$objWriter->setUseDiskCaching(true);
$objWriter->save("php://output");
两天前，它运行良好 . 但今天，它抛出异常： Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 85 bytes) in /..../Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 155
2 回答
另外需要注意的一点是，你是通过循环遍历一个名为$ data ....的数组来构建PHPExcel对象的，我猜测它是通过循环数据库查询的结果构建的 .
随着结果数量的增加，$ data数组也将使用大部分内存，每天都会有越来越多的内存 .
如果不是循环遍历数据库结果集来构建大型数组然后循环遍历该数组来构建PHPExcel数据，那么通过数据库结果集循环并直接构建PHPExcel数据将会更有效 . 这消除了$ data的内存开销，并将2个循环减少到1 .
请记住，除了PHPExcel对象使用的内存之外，PHP还使用内存和脚本本身 .
如果使用memoryCacheSize设置cache_to_phpTemp，则PHPExcel对象将使用内存达到该限制，然后切换到使用临时文件 . 您的memoryCacheSize与绝对的php.ini内存限制（128MB）相同，因此在达到PHP自身的限制之前，PHPExcel永远不会切换到使用临时文件单元缓存 . 尝试设置较低的memoryCacheSize（例如64MB），这样至少PHPExcel将有机会缓存单元并减少自己的内存使用量 .