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

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);

?>