PHPExcel Fatal error

Topics: Developer Forum, Project Management Forum, User Forum
Sep 25, 2013 at 1:36 PM
i am trying to export large amount of data into xlsx file... by using PHPExcel_1.7.9

my problem is that i get every time an error Fatal error: PHPExcel allowed memory of size of 943718400 bytes exhausted in classes/PHPexcel/worksheet.php on line 114

i added in my file the below lines:
ini_set('max_execution_time', 0);// unlimited
ini_set('memory_limit', '-1');// unlimited

but it did not solve my problem.. also in my php.ini i added the below lines

memory_limit = 900M
upload_max_filesize = 600M
post_max_size = 600M
max_execution_time = 300000000
max_input_time = 300000000
session.gc_maxlifetime = 28800

max_input_vars = 3000
php_value suhosin.get.max_vars 3000
php_value 3000
php_value suhosin.request.max_vars 3000

and also i did not work for me.... please i need help as soon as possible
Sep 25, 2013 at 2:14 PM
So which of the cell caching methods for reducing memory usage have you tried?
Sep 25, 2013 at 3:17 PM
MarkBaker wrote:
So which of the cell caching methods for reducing memory usage have you tried?
i don't understand you... please advice
Sep 25, 2013 at 5:43 PM
The different methods of cache implemented by PHPExcel to reduce the memory requirements.

May I suggest you read the documentation, in particular chapter 4.2.1?
The examples '06largescale-with - cellcaching [...].PHP"are also very informative on this subject.

Mark: Sorry to intrude on the subject.
Sep 30, 2013 at 1:48 PM
i tried to use the large scale with cell caching but it still shows the error for me.. the problem is that i have to explode 500.000 record per time to *.xlsx file.

how i can help it?? it made me crazy..

please advice
Oct 1, 2013 at 12:39 PM
Have you tried the method of cache with sqlite3?

You have 500000 lines (multiplied by fields / columns) for each file? Or you ventilated these recordings between different files?