phpExcel导出大量数据出现内存溢出错误解决办法

PHPExcel_Settings::setCacheStorageMethod()

PHPExcel_CachedObjectStorageFactory::cache_in_memory_serialized; 

PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip; 

PHPExcel_CachedObjectStorageFactory::cache_to_discISAM;

PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp; 

$cacheMethod = PHPExcel_CachedObjectStorageFactory:: cache_to_phpTemp; 
$cacheSettings = array( ' memoryCacheSize '  => '8MB' 
                ); 
PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings); 

$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_memcache; 
$cacheSettings = array( 'memcacheServer'  => 'localhost', 
                        'memcachePort'    => 11211, 
                        'cacheTime'       => 600 
                      ); 
PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);

$sheet = $objPHPExcel->getActiveSheet(); 

$sheet->setCellValue('A1',$x);  

$sheet->setCellValue('B1',$y);

export to Excel 

$('#export').click(function() {  

    $.ajax({  

        url: "export.php",   

        data: getData(),  //这个地方你也可以在php里获取，一般读数据库  

        success: function(response){  

            window.location.href = response.url;  

        }  

    })  

});

//export.php 

$data = $_POST['data'];

$xls = new PHPExcel(); 

$xls->loadData($formattedData);

$xls->exportToFile('excel.xls');

$response = array( 

'success' => true, 

'url' => $url 

); 

header('Content-type: application/json'); 

echo json_encode($response); 

?>