write.xlsx error message

? Thu, 14 Mar 2024 14:12:12 +0000
Subia Thomas OI-US-LIV5 <Thomas.Subia at draexlmaier.com> ?????:

Using write.xlsx to extract data from an Excel file, I get this error
message.


Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod",
cl,  : java.lang.OutOfMemoryError: GC overhead limit exceeded

There seems to be a default limit of 512 megabytes for the Java heap
size:

library(rJava)
getOption('java.parameters')
# [1] "-Xmx512m"

Does if help if you set options(java.parameters = '-Xmx2048m') (or
as much as you feel comfortable with) before loading XLConnect?

Best regards,
Ivan