Jun 22, 2011 at 4:05 PM
Edited Jun 22, 2011 at 4:06 PM
I am using PHPexcel for excel generation.It works fine for small data set.
$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_discISAM;
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $ex_row, $value);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
I having huge data result of more than 60000 records with 60 columns.
I think PHPExcel is setting values and everything saved in object array and at last its writing to the file.
As PHP is not good with arrays and data is huge am getting request time out error.
To avoid that am planning to write row by row and save each time
Is it possible that I can write row by row to the excel file and save it at the end?
While creating csv with php it was successful for writing huge data. Can it be done using phpexcel
append each row by row