Memory Spike While Setting Values

Topics: Developer Forum
Oct 23, 2009 at 6:54 PM
Edited Oct 23, 2009 at 6:55 PM

I am using verion 1.7.0 and itterating through a array returned form a database, it has 68 columns and 831 rows. The code using is below. If you notice in the output, memory is neglible by PHP's mesaure, then all of a sudden it spikes, going up .25 megs every 4 rows. I have no idea what is wrong, but this seems to huge memory usage for that size dataset.

Any help is greatly appreciated,

Mike

----

Code

----

print "BEFORE ".(memory_get_usage(true) / 1024 / 1024)."<br>";

  foreach ($dbResult as $fields) {
   $col = 0;

   foreach ($fields as $field) {
    $objExcel->getActiveSheet()->setCellValueExplicitByColumnAndRow($col, $row, $field, PHPExcel_Cell_DataType::TYPE_STRING);
    $col++;
   }

print "AFTER EACH ROW ".(memory_get_usage(true) / 1024 / 1024)."<br>";

   $row++;
  }

 

------

Output

------

BEFORE 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 24.75
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.25
AFTER EACH ROW 25.5
AFTER EACH ROW 25.5
AFTER EACH ROW 25.5
AFTER EACH ROW 25.5
AFTER EACH ROW 25.75
AFTER EACH ROW 25.75
AFTER EACH ROW 25.75
AFTER EACH ROW 25.75
AFTER EACH ROW 25.75
AFTER EACH ROW 26
AFTER EACH ROW 26
AFTER EACH ROW 26
AFTER EACH ROW 26
AFTER EACH ROW 26.25
AFTER EACH ROW 26.25
AFTER EACH ROW 26.25
AFTER EACH ROW 26.25
AFTER EACH ROW 26.5
AFTER EACH ROW 26.5
AFTER EACH ROW 26.5
AFTER EACH ROW 26.5
AFTER EACH ROW 27
AFTER EACH ROW 27
AFTER EACH ROW 27
AFTER EACH ROW 27
AFTER EACH ROW 27.25
AFTER EACH ROW 27.25
AFTER EACH ROW 27.25
AFTER EACH ROW 27.25
AFTER EACH ROW 27.25
AFTER EACH ROW 27.5
AFTER EACH ROW 27.5
AFTER EACH ROW 27.5
AFTER EACH ROW 27.5
AFTER EACH ROW 27.75
AFTER EACH ROW 27.75
AFTER EACH ROW 27.75
AFTER EACH ROW 27.75
AFTER EACH ROW 27.75
AFTER EACH ROW 28
AFTER EACH ROW 28
AFTER EACH ROW 28
AFTER EACH ROW 28
AFTER EACH ROW 28.25
AFTER EACH ROW 28.25
AFTER EACH ROW 28.25
AFTER EACH ROW 28.25
AFTER EACH ROW 28.5
AFTER EACH ROW 28.5
AFTER EACH ROW 28.5
AFTER EACH ROW 28.5
AFTER EACH ROW 28.75
AFTER EACH ROW 28.75
AFTER EACH ROW 28.75
AFTER EACH ROW 28.75
AFTER EACH ROW 29
AFTER EACH ROW 29
AFTER EACH ROW 29
AFTER EACH ROW 29
AFTER EACH ROW 29
AFTER EACH ROW 29.25
AFTER EACH ROW 29.25
AFTER EACH ROW 29.25
AFTER EACH ROW 29.25
AFTER EACH ROW 29.5
AFTER EACH ROW 29.5
AFTER EACH ROW 29.5
AFTER EACH ROW 29.5
AFTER EACH ROW 29.75
AFTER EACH ROW 29.75
AFTER EACH ROW 29.75
AFTER EACH ROW 29.75
AFTER EACH ROW 30
AFTER EACH ROW 30
AFTER EACH ROW 30
AFTER EACH ROW 30
AFTER EACH ROW 30.25
AFTER EACH ROW 30.25
AFTER EACH ROW 30.25
AFTER EACH ROW 30.25
AFTER EACH ROW 30.5
AFTER EACH ROW 30.5
AFTER EACH ROW 30.5
AFTER EACH ROW 30.5
AFTER EACH ROW 30.5
AFTER EACH ROW 30.75
AFTER EACH ROW 30.75
AFTER EACH ROW 30.75
AFTER EACH ROW 30.75
AFTER EACH ROW 31
AFTER EACH ROW 31
AFTER EACH ROW 31
AFTER EACH ROW 31
AFTER EACH ROW 31.25
AFTER EACH ROW 31.25
AFTER EACH ROW 31.25
AFTER EACH ROW 31.25
AFTER EACH ROW 31.5
AFTER EACH ROW 31.5
AFTER EACH ROW 31.5
AFTER EACH ROW 31.5
AFTER EACH ROW 31.75
AFTER EACH ROW 31.75
AFTER EACH ROW 31.75
AFTER EACH ROW 31.75
AFTER EACH ROW 32
AFTER EACH ROW 32
AFTER EACH ROW 32
AFTER EACH ROW 32
AFTER EACH ROW 32.25
AFTER EACH ROW 32.25
AFTER EACH ROW 32.25
AFTER EACH ROW 32.25
AFTER EACH ROW 32.25
AFTER EACH ROW 32.5
AFTER EACH ROW 32.5
AFTER EACH ROW 32.5
AFTER EACH ROW 32.5
AFTER EACH ROW 32.75
AFTER EACH ROW 32.75
AFTER EACH ROW 32.75
AFTER EACH ROW 32.75
AFTER EACH ROW 33
AFTER EACH ROW 33
AFTER EACH ROW 33
AFTER EACH ROW 33
AFTER EACH ROW 33.25
AFTER EACH ROW 33.25
AFTER EACH ROW 33.25
AFTER EACH ROW 33.25
AFTER EACH ROW 33.5
AFTER EACH ROW 33.5
AFTER EACH ROW 33.5
AFTER EACH ROW 33.5
AFTER EACH ROW 33.75
AFTER EACH ROW 33.75
AFTER EACH ROW 33.75
AFTER EACH ROW 33.75
AFTER EACH ROW 33.75
AFTER EACH ROW 34
AFTER EACH ROW 34
AFTER EACH ROW 34
AFTER EACH ROW 34.5
AFTER EACH ROW 34.75
AFTER EACH ROW 34.75
AFTER EACH ROW 34.75
AFTER EACH ROW 35
AFTER EACH ROW 35
AFTER EACH ROW 35
AFTER EACH ROW 35
AFTER EACH ROW 35.25
AFTER EACH ROW 35.25
AFTER EACH ROW 35.25
AFTER EACH ROW 35.25
AFTER EACH ROW 35.5
AFTER EACH ROW 35.5
AFTER EACH ROW 35.5
AFTER EACH ROW 35.5
AFTER EACH ROW 35.75
AFTER EACH ROW 35.75
AFTER EACH ROW 35.75
AFTER EACH ROW 35.75
AFTER EACH ROW 36
AFTER EACH ROW 36
AFTER EACH ROW 36
AFTER EACH ROW 36
AFTER EACH ROW 36
AFTER EACH ROW 36.25
AFTER EACH ROW 36.25
AFTER EACH ROW 36.25
AFTER EACH ROW 36.25
AFTER EACH ROW 36.5
AFTER EACH ROW 36.5
AFTER EACH ROW 36.5
AFTER EACH ROW 36.5
AFTER EACH ROW 36.75
AFTER EACH ROW 36.75
AFTER EACH ROW 36.75
AFTER EACH ROW 36.75
AFTER EACH ROW 37
AFTER EACH ROW 37
AFTER EACH ROW 37
AFTER EACH ROW 37
AFTER EACH ROW 37.25
AFTER EACH ROW 37.25
AFTER EACH ROW 37.25
AFTER EACH ROW 37.25
AFTER EACH ROW 37.5
AFTER EACH ROW 37.5
AFTER EACH ROW 37.5
AFTER EACH ROW 37.5
AFTER EACH ROW 37.5
AFTER EACH ROW 37.75
AFTER EACH ROW 37.75
AFTER EACH ROW 37.75
AFTER EACH ROW 37.75
AFTER EACH ROW 38
AFTER EACH ROW 38
AFTER EACH ROW 38
AFTER EACH ROW 38
AFTER EACH ROW 38.25
AFTER EACH ROW 38.25
AFTER EACH ROW 38.25
AFTER EACH ROW 38.25
AFTER EACH ROW 38.5
AFTER EACH ROW 38.5
AFTER EACH ROW 38.5
AFTER EACH ROW 38.5
AFTER EACH ROW 38.75
AFTER EACH ROW 38.75
AFTER EACH ROW 38.75
AFTER EACH ROW 38.75
AFTER EACH ROW 39
AFTER EACH ROW 39
AFTER EACH ROW 39
AFTER EACH ROW 39
AFTER EACH ROW 39
AFTER EACH ROW 39.25
AFTER EACH ROW 39.25
AFTER EACH ROW 39.25
AFTER EACH ROW 39.25
AFTER EACH ROW 39.5
AFTER EACH ROW 39.5
AFTER EACH ROW 39.5
AFTER EACH ROW 39.5
AFTER EACH ROW 39.75
AFTER EACH ROW 39.75
AFTER EACH ROW 39.75
AFTER EACH ROW 39.75
AFTER EACH ROW 40
AFTER EACH ROW 40
AFTER EACH ROW 40
AFTER EACH ROW 40
AFTER EACH ROW 40.25
AFTER EACH ROW 40.25
AFTER EACH ROW 40.25
AFTER EACH ROW 40.25
AFTER EACH ROW 40.5
AFTER EACH ROW 40.5
AFTER EACH ROW 40.5
AFTER EACH ROW 40.5
AFTER EACH ROW 40.5
AFTER EACH ROW 40.75
AFTER EACH ROW 40.75
AFTER EACH ROW 40.75
AFTER EACH ROW 40.75
AFTER EACH ROW 41
AFTER EACH ROW 41
AFTER EACH ROW 41
AFTER EACH ROW 41
AFTER EACH ROW 41.25
AFTER EACH ROW 41.25
AFTER EACH ROW 41.25
AFTER EACH ROW 41.25
AFTER EACH ROW 41.5
AFTER EACH ROW 41.5
AFTER EACH ROW 41.5
AFTER EACH ROW 41.5
AFTER EACH ROW 41.75
AFTER EACH ROW 41.75
AFTER EACH ROW 41.75
AFTER EACH ROW 41.75
AFTER EACH ROW 42
AFTER EACH ROW 42
AFTER EACH ROW 42
AFTER EACH ROW 42
AFTER EACH ROW 42.25
AFTER EACH ROW 42.25
AFTER EACH ROW 42.25
AFTER EACH ROW 42.25
AFTER EACH ROW 42.25
AFTER EACH ROW 42.5
AFTER EACH ROW 42.5
AFTER EACH ROW 42.5
AFTER EACH ROW 42.5
AFTER EACH ROW 42.75
AFTER EACH ROW 42.75
AFTER EACH ROW 42.75
AFTER EACH ROW 42.75
AFTER EACH ROW 43
AFTER EACH ROW 43
AFTER EACH ROW 43
AFTER EACH ROW 43
AFTER EACH ROW 43.25
AFTER EACH ROW 43.25
AFTER EACH ROW 43.25
AFTER EACH ROW 43.25
AFTER EACH ROW 43.5
AFTER EACH ROW 43.5
AFTER EACH ROW 43.5
AFTER EACH ROW 43.5
AFTER EACH ROW 43.75
AFTER EACH ROW 43.75
AFTER EACH ROW 43.75
AFTER EACH ROW 43.75
AFTER EACH ROW 43.75
AFTER EACH ROW 44
AFTER EACH ROW 44
AFTER EACH ROW 44
AFTER EACH ROW 44
AFTER EACH ROW 44.25
AFTER EACH ROW 44.25
AFTER EACH ROW 44.25
AFTER EACH ROW 44.25
AFTER EACH ROW 44.5
AFTER EACH ROW 44.5
AFTER EACH ROW 44.5
AFTER EACH ROW 44.5
AFTER EACH ROW 44.75
AFTER EACH ROW 44.75
AFTER EACH ROW 44.75
AFTER EACH ROW 44.75
AFTER EACH ROW 45
AFTER EACH ROW 45
AFTER EACH ROW 45
AFTER EACH ROW 45
AFTER EACH ROW 45.25
AFTER EACH ROW 45.25
AFTER EACH ROW 45.25
AFTER EACH ROW 45.25
AFTER EACH ROW 45.25
AFTER EACH ROW 45.5
AFTER EACH ROW 45.5
AFTER EACH ROW 45.5
AFTER EACH ROW 45.5
AFTER EACH ROW 45.75
AFTER EACH ROW 45.75
AFTER EACH ROW 45.75
AFTER EACH ROW 45.75
AFTER EACH ROW 46
AFTER EACH ROW 46
AFTER EACH ROW 46
AFTER EACH ROW 46
AFTER EACH ROW 46.25
AFTER EACH ROW 46.25
AFTER EACH ROW 46.25
AFTER EACH ROW 46.25
AFTER EACH ROW 46.5
AFTER EACH ROW 46.5
AFTER EACH ROW 46.5
AFTER EACH ROW 46.5
AFTER EACH ROW 46.75
AFTER EACH ROW 46.75
AFTER EACH ROW 46.75
AFTER EACH ROW 46.75
AFTER EACH ROW 47
AFTER EACH ROW 47
AFTER EACH ROW 47
AFTER EACH ROW 47
AFTER EACH ROW 47
AFTER EACH ROW 47.25
AFTER EACH ROW 47.25
AFTER EACH ROW 47.25
AFTER EACH ROW 47.25
AFTER EACH ROW 47.5
AFTER EACH ROW 47.5
AFTER EACH ROW 47.5
AFTER EACH ROW 47.5
AFTER EACH ROW 47.75
AFTER EACH ROW 47.75
AFTER EACH ROW 47.75
AFTER EACH ROW 47.75
AFTER EACH ROW 48
AFTER EACH ROW 48
AFTER EACH ROW 48
AFTER EACH ROW 48
AFTER EACH ROW 48.25
AFTER EACH ROW 48.25
AFTER EACH ROW 48.25
AFTER EACH ROW 48.25
AFTER EACH ROW 48.5
AFTER EACH ROW 48.5
AFTER EACH ROW 48.5
AFTER EACH ROW 48.5
AFTER EACH ROW 48.5
AFTER EACH ROW 48.75
AFTER EACH ROW 48.75
AFTER EACH ROW 48.75
AFTER EACH ROW 48.75
AFTER EACH ROW 49
AFTER EACH ROW 49
AFTER EACH ROW 49
AFTER EACH ROW 49
AFTER EACH ROW 50.25
AFTER EACH ROW 50.25
AFTER EACH ROW 50.75
AFTER EACH ROW 50.75
AFTER EACH ROW 50.75
AFTER EACH ROW 50.75
AFTER EACH ROW 51
AFTER EACH ROW 51
AFTER EACH ROW 51
AFTER EACH ROW 51
AFTER EACH ROW 51.25
AFTER EACH ROW 51.25
AFTER EACH ROW 51.25
AFTER EACH ROW 51.25
AFTER EACH ROW 51.5
AFTER EACH ROW 51.5
AFTER EACH ROW 51.5
AFTER EACH ROW 51.5
AFTER EACH ROW 51.5
AFTER EACH ROW 51.75
AFTER EACH ROW 51.75
AFTER EACH ROW 51.75
AFTER EACH ROW 51.75
AFTER EACH ROW 52
AFTER EACH ROW 52
AFTER EACH ROW 52
AFTER EACH ROW 52
AFTER EACH ROW 52.25
AFTER EACH ROW 52.25
AFTER EACH ROW 52.25
AFTER EACH ROW 52.25
AFTER EACH ROW 52.5
AFTER EACH ROW 52.5
AFTER EACH ROW 52.5
AFTER EACH ROW 52.5
AFTER EACH ROW 52.75
AFTER EACH ROW 52.75
AFTER EACH ROW 52.75
AFTER EACH ROW 52.75
AFTER EACH ROW 53
AFTER EACH ROW 53
AFTER EACH ROW 53
AFTER EACH ROW 53
AFTER EACH ROW 53
AFTER EACH ROW 53.25
AFTER EACH ROW 53.25
AFTER EACH ROW 53.25
AFTER EACH ROW 53.25
AFTER EACH ROW 53.5
AFTER EACH ROW 53.5
AFTER EACH ROW 53.5
AFTER EACH ROW 53.5
AFTER EACH ROW 53.75
AFTER EACH ROW 53.75
AFTER EACH ROW 53.75
AFTER EACH ROW 53.75
AFTER EACH ROW 54
AFTER EACH ROW 54
AFTER EACH ROW 54
AFTER EACH ROW 54
AFTER EACH ROW 54.25
AFTER EACH ROW 54.25
AFTER EACH ROW 54.25
AFTER EACH ROW 54.25
AFTER EACH ROW 54.5
AFTER EACH ROW 54.5
AFTER EACH ROW 54.5
AFTER EACH ROW 54.5
AFTER EACH ROW 54.5
AFTER EACH ROW 54.75
AFTER EACH ROW 54.75
AFTER EACH ROW 54.75
AFTER EACH ROW 54.75
AFTER EACH ROW 55
AFTER EACH ROW 55
AFTER EACH ROW 55
AFTER EACH ROW 55
AFTER EACH ROW 55.25
AFTER EACH ROW 55.25
AFTER EACH ROW 55.25
AFTER EACH ROW 55.25
AFTER EACH ROW 55.5
AFTER EACH ROW 55.5
AFTER EACH ROW 55.5
AFTER EACH ROW 55.5
AFTER EACH ROW 55.75
AFTER EACH ROW 55.75
AFTER EACH ROW 55.75
AFTER EACH ROW 55.75
AFTER EACH ROW 56
AFTER EACH ROW 56
AFTER EACH ROW 56
AFTER EACH ROW 56
AFTER EACH ROW 56.25
AFTER EACH ROW 56.25
AFTER EACH ROW 56.25
AFTER EACH ROW 56.25
AFTER EACH ROW 56.25
AFTER EACH ROW 56.5
AFTER EACH ROW 56.5
AFTER EACH ROW 56.5
AFTER EACH ROW 56.5
AFTER EACH ROW 56.75
AFTER EACH ROW 56.75
AFTER EACH ROW 56.75
AFTER EACH ROW 56.75
AFTER EACH ROW 57
AFTER EACH ROW 57
AFTER EACH ROW 57
AFTER EACH ROW 57
AFTER EACH ROW 57.25
AFTER EACH ROW 57.25
AFTER EACH ROW 57.25
AFTER EACH ROW 57.25
AFTER EACH ROW 57.5
AFTER EACH ROW 57.5
AFTER EACH ROW 57.5
AFTER EACH ROW 57.5
AFTER EACH ROW 57.75
AFTER EACH ROW 57.75
AFTER EACH ROW 57.75
AFTER EACH ROW 57.75
AFTER EACH ROW 57.75
AFTER EACH ROW 58
AFTER EACH ROW 58
AFTER EACH ROW 58
AFTER EACH ROW 58
AFTER EACH ROW 58.25
AFTER EACH ROW 58.25
AFTER EACH ROW 58.25
AFTER EACH ROW 58.25
AFTER EACH ROW 58.5
AFTER EACH ROW 58.5
AFTER EACH ROW 58.5
AFTER EACH ROW 58.5
AFTER EACH ROW 58.75
AFTER EACH ROW 58.75
AFTER EACH ROW 58.75
AFTER EACH ROW 58.75
AFTER EACH ROW 59
AFTER EACH ROW 59
AFTER EACH ROW 59
AFTER EACH ROW 59
AFTER EACH ROW 59.25
AFTER EACH ROW 59.25
AFTER EACH ROW 59.25
AFTER EACH ROW 59.25
AFTER EACH ROW 59.25
AFTER EACH ROW 59.5
AFTER EACH ROW 59.5
AFTER EACH ROW 59.5
AFTER EACH ROW 59.5
AFTER EACH ROW 59.75
AFTER EACH ROW 59.75
AFTER EACH ROW 59.75
AFTER EACH ROW 59.75
AFTER EACH ROW 60
AFTER EACH ROW 60
AFTER EACH ROW 60
AFTER EACH ROW 60
AFTER EACH ROW 60.25
AFTER EACH ROW 60.25
AFTER EACH ROW 60.25
AFTER EACH ROW 60.25
AFTER EACH ROW 60.5
AFTER EACH ROW 60.5
AFTER EACH ROW 60.5
AFTER EACH ROW 60.5
AFTER EACH ROW 60.75
AFTER EACH ROW 60.75
AFTER EACH ROW 60.75
AFTER EACH ROW 60.75
AFTER EACH ROW 60.75
AFTER EACH ROW 61
AFTER EACH ROW 61
AFTER EACH ROW 61
AFTER EACH ROW 61
AFTER EACH ROW 61.25
AFTER EACH ROW 61.25
AFTER EACH ROW 61.25
AFTER EACH ROW 61.25
AFTER EACH ROW 61.5
AFTER EACH ROW 61.5
AFTER EACH ROW 61.5
AFTER EACH ROW 61.5
AFTER EACH ROW 61.75
AFTER EACH ROW 61.75
AFTER EACH ROW 61.75
AFTER EACH ROW 61.75
AFTER EACH ROW 62
AFTER EACH ROW 62
AFTER EACH ROW 62
AFTER EACH ROW 62
AFTER EACH ROW 62.25
AFTER EACH ROW 62.25
AFTER EACH ROW 62.25
AFTER EACH ROW 62.25
AFTER EACH ROW 62.5
AFTER EACH ROW 62.5
AFTER EACH ROW 62.5
AFTER EACH ROW 62.5
AFTER EACH ROW 62.5
AFTER EACH ROW 62.75
AFTER EACH ROW 62.75
AFTER EACH ROW 62.75
AFTER EACH ROW 62.75
AFTER EACH ROW 63
AFTER EACH ROW 63
AFTER EACH ROW 63
AFTER EACH ROW 63
AFTER EACH ROW 63.25
AFTER EACH ROW 63.25
AFTER EACH ROW 63.25
AFTER EACH ROW 63.25
AFTER EACH ROW 63.5
AFTER EACH ROW 63.5
AFTER EACH ROW 63.5
AFTER EACH ROW 63.5
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 63.75
AFTER EACH ROW 64
AFTER EACH ROW 64
AFTER EACH ROW 64
AFTER EACH ROW 64
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 35 bytes) in C:\*****\phpexcel\lib\PHPExcel\Cell.php on line 510

Developer
Oct 23, 2009 at 10:00 PM

You must estimate approximately 1KB memory usage per cell. With 68 columns, that fits pretty well with .25MB per 4 rows like you are saying.

We wish to reduce memory usage via a cache provider for the collection of cells. See this work item

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=6857

Until then, I'm afraid there is no solution to reduce memory usage.