Optimizing execution speed of writing a Worksheet

Topics: Developer Forum, User Forum
Jun 29, 2014 at 5:10 AM
Hello guys!

I am using PHPExcel to generate a report.
Problem is that it takes very long time, approx 30 secs for a limited subset of 1000 rows entries.

Profiling on 1000 rows, shows the majority of the execution time is lost on the save operation, split mostly between the PHPExcel_Writer_Excel2007_Worksheet->_writeCols and PHPExcel_Writer_Excel2007_Worksheet->_writeSheetData (picture attached).

The end of the code used to generate the report:
$objPHPExcel = new PHPExcel();
..... lot of irrelevant lines...
    $ExcelWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
Profiling for 1000 rows: Screenshot

Any ideas for ways to optimize the saving? to make it more scalable for much bigger reports?