Feb 18, 2011 at 3:46 PM
Edited Feb 18, 2011 at 4:36 PM
I am using a lot of formulas so I added the setPreCalculateFormulas(false) just now and will run another test. I am also having memory issues still as my current test just failed with this:
PHP Fatal error: Out of memory (allocated 226230272) (tried to allocate 15630559 bytes) in /phpscripts/cli/includes/PHPExcel/Shared/XMLWriter.php on line 100
As for the other things, I am not using autofit, I am applying styles by range, and my formats are mostly currency with custom format codes.
Also, guess I need to figure out if the writer or the building of the object is my hold up, but my initial tests lead me to believe that populating the PHPExcel object is going very slowly - so it could be a little of both
OK, after digging a little deeper the issue is the DEFINITELY writing. It populates the object in an acceptable amount of time.