title: EPPlus Large Dataset Issue with Out of Memory Exception
body: <p>System Out of Memory Exception. I see the memory Stream is only flushed when saved. We have 1.5 - 2GB Datasets.</p>
  
  <p>I am using EPPlus Version 3.1.3.0 </p>
  
  <p>We do the following in code.</p>
  
  <p>We loop through </p>
  
  <pre><code>     --&gt; Create a Package
          --&gt; each table in the datareader
              --&gt;   Add WorkSheet to the Package 
          --&gt; Dispose Each table.
       --&gt; Save the  Package.
  </code></pre>
  
  <p>Each Datatable is of a 300Mg Size up to 15 Tables out form the System.</p>
  
  <p>This is causing a issue, I have logged this in detail @ <a href="https://epplus.codeplex.com/workitem/15085" rel="noreferrer">https://epplus.codeplex.com/workitem/15085</a></p>
  
  <p>I still want to be able to use EPPlus its very nice API. but is there a better way to free up a worksheet once we add it to the package.</p>
  
  <p>Thank you for helping.</p>