Re: [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.su...@draexlmaier.com
http://www.draexlmaier.com

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


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

[You don't often get email from gernop...@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" 
An: "Subia Thomas OI-US-LIV5" 
Cc: "r-help@r-project.org" 
Betreff: Re: [R] write.xlsx error message В Thu, 14 Mar 2024 14:12:12 + 
Subia Thomas OI-US-LIV5  пишет:

> 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[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.

__
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.

[R] write.xlsx error message

[Subia Thomas OI-US-LIV5]

Colleagues,

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

I was thinking that this might be a RAM issue but with 16 GB RAM, I wasn't 
expecting this error message.

Any guidance would be appreciated.

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

DR�XLMAIER Group
DAA Draexlmaier Automotive of America LLC


mailto:thomas.su...@draexlmaier.com
http://www.draexlmaier.com

"Nous croyons en Dieu.
Tous les autres doivent apporter des donn�es.
Edward Deming



Public

[[alternative HTML version deleted]]

__
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.

[R] annotate

[Subia Thomas OI-US-LIV5]

Colleagues,

I wish to create y-data labels which meet a criterion.

Here is my reproducible code.
library(dplyr)
library(ggplot2)
library(cowplot)

above_92 <- filter(faithful,waiting>92)

ggplot(faithful,aes(x=eruptions,y=waiting))+
  geom_point(shape=21,size=3,fill="orange")+
  theme_cowplot()+
  geom_hline(yintercept = 92)+
  
annotate(geom="text",x=above_92$eruptions,y=above_92$waiting+2,label=above_92$waiting)

A bit of trial and error is required to figure out what number to add or 
subtract to above_92$waiting.

Is there a more efficient way to do this?


Thomas Subia
Lean Six Sigma Senior Practitioner

DRÄXLMAIER Group
DAA Draexlmaier Automotive of America LLC

mailto:thomas.su...@draexlmaier.com
http://www.draexlmaier.com

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


Public: All rights reserved. Distribution to third parties allowed.

__
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.