PEAR Forum :: PHP Extension and Application Repository

PEAR Forum Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
PEAR Spreadsheet Excel Writer memory exhausted

 
Post new topic   Reply to topic    PEAR Forum Forum Index -> What do you miss in/about PEAR?
View previous topic :: View next topic  
Author Message
ozzy86



Joined: 07 Apr 2011
Posts: 1

PostPosted: Thu Apr 07, 2011 2:43 pm    Post subject: PEAR Spreadsheet Excel Writer memory exhausted Reply with quote

Hello

Got a strange problem when trying to create a quite heavy excel file (1.8M). It only works if I set php_value memory_limit 1250M.
The created excel file is constantly growing in size due to new data inserted in DB. So I have to increase memory_limit all the time, which is not very cool, as u understand:)
If I don't increase this value the script will give me fatal error:
Allowed memory size of 587202560 bytes exhausted (tried to allocate 205455 bytes) in /usr/share/php/Spreadsheet/Excel/Writer/BIFFwriter.php on line 158

So I am looking for any method to reduce this unbelievable memory usage.

Any help will be much appreciated:)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    PEAR Forum Forum Index -> What do you miss in/about PEAR? All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



PEAR Forum topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group

Provided by Ministry of Web developement