# Memory Spike While Setting Values

 Topics: Developer Forum Wiki Link: [discussion:72917]
 greetingsc Oct 23, 2009 at 7:54 PM Edited Oct 23, 2009 at 7: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)."
";   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)."
";    \$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 koyama Developer Oct 23, 2009 at 11: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.