[R] write.xlsx error message

[Subia Thomas OI-US-LIV5]

Good point, indeed it should have been read.xlsx.



Mit freundlichen Gruessen  / Cordialement / Best regards
Thomas Subia
Lean Six Sigma Senior Practitioner

DRÄXLMAIER Group
DAA Draexlmaier Automotive of America LLC
801 Challenger Street
Livermore CA 94551

Ph:     925-978-8111

mailto:thomas.subia using draexlmaier.com
http://www.draexlmaier.com

“Nous croyons en Dieu.
Tous les autres doivent apporter des données.
Edward Deming


Public
-----Original Message-----
From: gernophil using gmx.net <gernophil using gmx.net>
Sent: Friday, March 15, 2024 1:07 AM
To: Subia Thomas OI-US-LIV5 <Thomas.Subia using draexlmaier.com>; r-help using r-project.org
Subject: Aw: Re: [R] write.xlsx error message

[You don't often get email from gernophil using gmx.net. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]

Caution: This email originated from outside the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

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.