Hi Matthew, The problem is that the underlying JVM is running with a fixed maximum heap size. When you load a workbook in XLConnect, an in-memory representation of that workbook is created (in Java by Apache POI). Reading and writing data additionally requires memory due to "communication" of your data from and to the JVM. Depending on the size of your workbooks and the data you are dealing with you may need to increase the maximum heap size available to the JVM. Please have a look at our FAQ at http://www.mirai-solutions.com/site/index.cfm?id_art=69890&actMenuItemID=31456&plainerr=yes&vsprache=EN on how to do this.
Other functions that you might be interested in are xlcMemoryReport and xlcFreeMemroy. Hope that helps. Best regards, Martin -- View this message in context: http://r.789695.n4.nabble.com/rJava-Out-of-Memory-Error-tp4647881p4648170.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
