title: xlConnect R use of JVM memory
body: <p>I'm running into a problem with JVM memory using <strong>XLConnect</strong> (Mirai Solutions) in R.  </p>
  
  <p>Data loads into R just fine using <code>loadWorkbook</code> or <code>readWorksheetFromFile</code>, but larger data (data frames about 3MB) get stuck while being written to the JVM during export with any of the export functions (<code>writeNamedRegion</code>, <code>writeWorksheetToFile</code>, etc.), and R stops responding.  </p>
  
  <p>I've reset the java parameters using <code>options(java.parameters = "-Xmx1500m")</code>, and this increased the size of the data frames I was able to export to Excel, but R still slows around 1MB and won't work around 3MB.  </p>
  
  <p>I'm on a 64-bit Windows 7 system with 32-bit Office software and 32-bit Java on a machine with 8GB RAM. 3MB doesn't seem very big compared to the ~750 MB free memory in the JVM that is supposedly there at the beginning of export (checked with <code>xlcMemoryReport</code>).  </p>
  
  <p>Ideas?  </p>