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 at 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 at gmx.net <gernophil at gmx.net>
Sent: Friday, March 15, 2024 1:07 AM
To: Subia Thomas OI-US-LIV5 <Thomas.Subia at draexlmaier.com>; r-help at
r-project.org
Subject: Aw: Re: [R] write.xlsx error message
[You don't often get email from gernophil at 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 at r-project.org>
An: "Subia Thomas OI-US-LIV5" <Thomas.Subia at draexlmaier.com>
Cc: "r-help at r-project.org" <r-help at 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 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
______________________________________________
R-help at 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.