PHPExcel - Can it write row by row as fetching from DB

Topics: Developer Forum, User Forum
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;



->getActiveSheet()->setCellValueByColumnAndRow($col, $ex_row, $value);  

= 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

Nov 15, 2013 at 7:32 AM
Edited Nov 15, 2013 at 7:32 AM
Were u able resolve your problem? If so how I am facing same problem, this PHPExcel is good package but it's not meant for Multiple user type web application, 2 or user trying to download perform of an excel data it is just no good, and or if it is large data-set forget it.