[R] write.xlsx error message

[ger@ophii m@iii@g oii gmx@@et]

I think remember this error from trying to write an Excel file that already existed. If this file already exists, try to delete it and see, if this solves the issue.

Besides that you're writing that you are "Using write.xlsx to extract data from an Excel file", write.xlsx() is to write an Excel file, not to read from it. Should be read.xlsx() then iirc.

 
 

Gesendet: Freitag, 15. März 2024 um 08:38 Uhr
Von: "Ivan Krylov via R-help" <r-help using r-project.org>
An: "Subia Thomas OI-US-LIV5" <Thomas.Subia using draexlmaier.com>
Cc: "r-help using r-project.org" <r-help using r-project.org>
Betreff: Re: [R] write.xlsx error message
В 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

______________________________________________
R-help using 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[http://www.R-project.org/posting-guide.html][http://www.R-project.org/posting-guide.html[http://www.R-project.org/posting-guide.html]]
and provide commented, minimal, self-contained, reproducible code.