Message-ID: <20240315103806.1d79cc4f@Tarkus>
Date: 2024-03-15T07:38:06Z
From: Ivan Krylov
Subject: write.xlsx error message
In-Reply-To: <PAXP190MB1839BBEA29CD25440ED49CCE8F292@PAXP190MB1839.EURP190.PROD.OUTLOOK.COM>
? 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