title: "Out of Memory Error (Java)" when using R and XLConnect package
body: <p>I tried to load a ~30MB excel spreadsheet into R using the XLConnect package. </p>
  
  <p>This is what I wrote:</p>
  
  <pre><code>wb &lt;- loadWorkbook("largespreadsheet.xlsx")
  </code></pre>
  
  <p>And after about 15 seconds, I got the following error: </p>
  
  <blockquote>
    <p>Error: OutOfMemoryError (Java): GC overhead limit exceeded.</p>
  </blockquote>
  
  <p>Is this a limitation of the XLConnect package or is there a way to tweak my memory settings to allow for larger files? </p>
  
  <p>I appreciate any solutions/tips/advice. </p>