I am new into PhpExcel, and try to tweak a little bit the code in order to generate an Excel5 file.
I read several threads regarding Cell Caching and memory set in PHP in order to write big files. However, none of those methods
allowed me to save (even generate) a file of about 30,000 rows in 3 sheets. I only have 256Mo of RAM, so cannot excess the 64Mo of allowed
memory for PHP.
So I try something, and I would like to have, if possible, a little bit of support :
In a PHP file, I set the header in order to save the generate file into a .xls file and permit the user to save it.
I have to extract approximately 30,000 rows from a DB and have to make a treatment and insert each of them in 3 differents sheets with Style (line affectation, in order to optimize a little bit).
So the thing we thought about was to call for each iteration the "save" method of the writer (here : Excel5) in order to get the file in real time and not let the object grow in memory.
We end up with a file, using 42Mo of disk space, but in which we had only one line printed in it : the first row in the first sheet.
Is this possible to write continuously in the .xls file ? If yes, what would be the good way ? The thing is to make all the possible not to let the phpExcel object grow in the memory.
Please let me know !
Thank You in Advance for your help