title: PHPExcel large data sets with multiple tabs - memory exhausted
body: <p>Using PHPExcel I can run each tab separately and get the results I want but if I add them all into one excel it just stops, no error or any thing.</p>
  
  <p>Each tab consists of about 60 to 80 thousand records and I have about 15 to 20 tabs. So about 1600000 records split into multiple tabs (This number will probably grow as well).</p>
  
  <p>Also I have tested the 65000 row limitation with .xls by using the .xlsx extension with no problems if I run each tab it it's own excel file.</p>
  
  <p>Pseudo code:</p>
  
  <p>read data from db
  start the PHPExcel process
  parse out data for each page (some styling/formatting but not much)
  (each numeric field value does get summed up in a totals column at the bottom of the excel using the formula SUM)
  save excel (xlsx format)</p>
  
  <p><s>I have 3GB of RAM so this is not an issue</s> and the script is set to execute with no timeout.</p>
  
  <p>I have used PHPExcel in a number of projects and have had great results but having such a large data set seems to be an issue.</p>
  
  <p>Anyone every have this problem? work around? tips? etc...</p>
  
  <p>UPDATE:</p>
  
  <p>on error log --- memory exhausted</p>
  
  <p>Besides adding more RAM to the box is there any other tips I could do?</p>
  
  <p>Anyone every save current state and edit excel with new data?</p>