В Thu, 14 Mar 2024 14:12:12 +0000
Subia Thomas OI-US-LIV5 <thomas.su...@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
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
