? 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