Insufficient memory

Topics: Developer Forum, User Forum
Feb 25, 2009 at 1:29 PM
Edited Feb 25, 2009 at 1:31 PM
Hello,

I'm having hard time to investigate, what is reason for following errors:
Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 75 bytes) in /pathtoscripts/Classes/PHPExcel/Style.php on line 466

What I want to is about 200kB size xls file with 10-15 sheets with 1-2 thousands of lines at 20 columns of mainly numerical data (+ few lines to make it look better). What is the freaking reason for 1GB memory not being enough?

Thanks for some hints.
M.
Developer
Feb 25, 2009 at 3:10 PM
This is unfortunately a known problem and a high priority issue. If you only need to read data, and not the styles, please use $objReader->setReadDataOnly(true). This will help reducing memory usage.

Feb 25, 2009 at 4:18 PM
Edited Feb 25, 2009 at 4:27 PM
I do not ready any data. I create blank document and generate all data in script. (Statistics from database).
Anyway, thanks for info.
Developer
Feb 26, 2009 at 8:06 AM
Can you try to look at example 23sharedstyles.php in the Tests folder? If you just need to dump data, using the methods from there, memory usage should be reduced.