关于PHPEXCEL输出报表有上万条记录的时候貌似挂了？-tutoriel php-php.cn

这是一个完整可用的phpexcel例子

getActiveSheet()->freezePane(&#39;A2&#39;);
$sharedStyle1 = new PHPExcel_Style();
$sharedStyle1->applyFromArray(    
array(&#39;fill&#39; => array(                
&#39;type&#39;	=> PHPExcel_Style_Fill::FILL_SOLID,                
&#39;color&#39;	=> array(&#39;argb&#39; => &#39;FFCCFFCC&#39;)            
),          
&#39;borders&#39; => array(                
&#39;bottom&#39;=> array(&#39;style&#39; => PHPExcel_Style_Border::BORDER_THIN),                
&#39;right&#39;	=> array(&#39;style&#39; => PHPExcel_Style_Border::BORDER_MEDIUM)                
)         
));
$sharedStyle2 = new PHPExcel_Style();
$sharedStyle2->applyFromArray(    
array(&#39;fill&#39; => array(                
&#39;type&#39;	=> PHPExcel_Style_Fill::FILL_SOLID,                
&#39;color&#39;	=> array(&#39;argb&#39; => &#39;fff4f4f4&#39;)            
)         
));
$objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "A1:O1");   
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;A&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;B&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;C&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;D&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;E&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;F&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;G&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;H&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;I&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;J&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;K&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;L&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;M&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;N&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension(&#39;O&#39;)->setWidth(50);
$objPHPExcel->getActiveSheet()->setTitle(&#39;Student Export&#39;);//?置?前工作表的名?
for($i=0;$igetActiveSheet()->getStyleByColumnAndRow($i, 1)->getFont()->setBold(true);//?置第一行?容加粗
}
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 1,&#39;First Name&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 1,&#39;Last Name&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 1,&#39;Date of Birth&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 1,&#39;Attendance Year&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 1,&#39;Course studied&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 1,&#39;Agency Booking / Direct Booking&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 1,&#39;Student Country&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 1,&#39;Student City&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 1,&#39;Student Home phone number&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 1,&#39;Student Mobile phone number&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, 1,&#39;Student Email address&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, 1,&#39;Emergency contact Name&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 1,&#39;Emergency contact phone number 1&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, 1,&#39;Emergency contact phone number 2&#39;);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 1,&#39;Order Date&#39;);$number=1;$orderdate=&#39;&#39;;
$firstname=&#39;&#39;;
$lastname=&#39;&#39;;
$dateodbirth=&#39;&#39;;
$attenddance=&#39;&#39;;
$studied=&#39;&#39;;
$booking=&#39;&#39;;
$country=&#39;&#39;;
$city=&#39;&#39;;
$home_phone=&#39;&#39;;
$mobile_phone=&#39;&#39;;
$email=&#39;&#39;;
$emer_name=&#39;&#39;;
$emer_phone1=&#39;&#39;;
$emer_phone2=&#39;&#39;;
$sql="select orders_id,date_purchased from orders order by orders_id desc";
$query=mysql_query($sql);
while($arr=mysql_fetch_array($query)){	
$number++;	
$orderdate=$arr[&#39;date_purchased&#39;];	
$sql2="select * from orders_extra_info where orders_id=&#39;".$arr[&#39;orders_id&#39;]."&#39;";	
$query2=mysql_query($sql2);	
$num2=mysql_num_rows($query2);	
if($num2>0)
{		
$arr2=mysql_fetch_array($query2);		
$firstname=$arr2[&#39;first_name&#39;];		
$lastname=$arr2[&#39;last_name&#39;];		
$dateodbirth=$arr2[&#39;date_of_birth&#39;];		
$attenddance=$arr2[&#39;o_attendaceyear&#39;];		
$booking=$arr2[&#39;o_agency&#39;];		
if($booking==1)
{
$booking=&#39;Direct Sale&#39;;
}		
if($booking==2)
{
$booking=&#39;Agent Sale&#39;;
}		
$country_id=$arr2[&#39;country&#39;];		
$city=$arr2[&#39;city&#39;];		
$home_phone=$arr2[&#39;phone1&#39;];		
$mobile_phone=$arr2[&#39;phone2&#39;];		
$email=$arr2[&#39;email&#39;];		
$emer_name=$arr2[&#39;emc_name&#39;];		
$emer_phone1=$arr2[&#39;emc_phone1&#39;];		
$emer_phone2=$arr2[&#39;emc_phone2&#39;];		
$cou_sql="select countries_id,countries_name from countries where countries_id=&#39;".$country_id."&#39;";		
$con_query=mysql_query($cou_sql);		
$con_arr=mysql_fetch_array($con_query);		
$country=$con_arr[&#39;countries_name&#39;];	
}	
$sql3="select products_name,orders_id from orders_products where orders_id=&#39;".$arr[&#39;orders_id&#39;]."&#39;";	
$query3=mysql_query($sql3);	
$num3=mysql_num_rows($query3);	
if($num3>0)
{		
$studied=&#39;&#39;;		
while($arr3=mysql_fetch_array($query3))
{			
$studied.=$arr3[&#39;products_name&#39;].",";		
}		
$studied=substr($studied,0,strlen($studied)-1);	
}	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $number,$firstname);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $number,$lastname);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $number,$dateodbirth);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $number,$attenddance);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $number,$studied);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $number,$booking);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $number,$country);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $number,$city);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $number,$home_phone);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $number,$mobile_phone);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $number,$email);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $number,$emer_name);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, $number,$emer_phone1);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, $number,$emer_phone2);	
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $number,$orderdate);
}
$objPHPExcel->setActiveSheetIndex(0);//?置打?excel??示哪?工作表
$excelName = &#39;Student_Export&#39;.date("YmdHis").&#39;.xls&#39;;//?置?出excel的文件名
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, &#39;Excel5&#39;);
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment; 
filename=".urlencode($excelName));
header("Content-Transfer-Encoding: binary");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: no-cache");
$objWriter->save(&#39;php://output&#39;);
require(DIR_WS_INCLUDES . &#39;application_bottom.php&#39;);
?>

Copier après la connexion

输出来的报表，当有上万条记录时，不能导出了，浏览器一直再转，只有小数据量的时候才有用，这时怎么办？

回复讨论(解决方案)

有以下几种缓存方式可以使用：
1). PHPExcel_CachedObjectStorageFactory::cache_in_memory;
      默认情况下，如果你不初始化任何缓存方式，PHPExcel将使用内存缓存的方式。
2).PHPExcel_CachedObjectStorageFactory::cache_in_memory_serialized;
     使用这种缓存方式，单元格会以序列化的方式保存在内存中，这是降低内存使用率性能比较高的一种方案。
3). PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip;
     与序列化的方式类似，这种方法在序列化之后，又进行gzip压缩之后再放入内存中，这回跟进一步降低内存的使用，但是读取和写入时会有一些慢。
4). PHPExcel_CachedObjectStorageFactory::cache_to_discISAM;
      当使用cache_to_discISAM这种方式时，所有的单元格将会保存在一个临时的磁盘文件中，只把他们的在文件中的位置保存在PHP的内存中，这会比任何一种缓存在内存中的方式都慢，但是能显著的降低内存的使用。临时磁盘文件在脚本运行结束是会自动删除。
5). PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp;
      类似cache_to_discISAM这种方式，使用cache_to_phpTemp时，所有的单元格会还存在php://temp I/O流中，只把他们的位置保存在PHP的内存中。PHP的php://memory包裹器将数据保存在内存中，php://temp的行为类似，但是当存储的数据大小超过内存限制时，会将数据保存在临时文件中，默认的大小是1MB，但是你可以在初始化时修改它:应该最多值能导出2万条。有以下几种缓存方式可以使用：

1). PHPExcel_CachedObjectStorageFactory::cache_in_memory;

默认情况下，如果你不初始化任何缓存方式，PHPExcel将使用内存缓存的方式。
2).PHPExcel_CachedObjectStorageFactory::cache_in_memory_seria……
内存问题，标记~

补充一下
PHPExcel 官网说，PHPExcel 以每个单元格 1K 的规模使用内存

据说可以什么分批导入？有没有例子怎么去写

自己到网上搜一下就是了

没哟这样的需求，谁会去测试?