[R] write.xlsx error message

[Ivan Krylov]

В Thu, 14 Mar 2024 14:12:12 +0000
Subia Thomas OI-US-LIV5 <Thomas.Subia using 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