OutOfMemoryError (Java) : Java heap space
<p>I'm trying to add 10 more rows at the end of an excel table (currently 27k rows long)</p>

<pre><code>options(java.parameters = "-Xmx4g" ) ; 
library(XLConnect) ;
writeWorksheetToFile("H:/R/myfile.xlsx",DataTable,sheet="Sheet1",startRow=row1,startCol=1,header=FALSE,rownames=FALSE) 
</code></pre>

<p>after some seconds I receive the error </p>

<p>OutOfMemoryError (Java) : Java heap space</p>

<p>How can I fix this? Shouldn't options(java.parameters = "-Xmx4g" ) work?</p>