Re: [R] write.xlsx error message

2024-03-15 Thread Subia Thomas OI-US-LIV5
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] wr

Re: [R] write.xlsx error message

2024-03-15 Thread gernophil--- via R-help
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 В Th

Re: [R] write.xlsx error message

2024-03-15 Thread Ivan Krylov via R-help
В 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 se

[R] write.xlsx error message

2024-03-15 Thread 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

Re: [R] write.xlsx

2017-03-11 Thread peter dalgaard
Also, this is from a package. Which? (AFAIR, there are at least two possibilities). What is is the docs? Does it even allow an append= argument? -pd > On 10 Mar 2017, at 14:49 , Michael Dewey wrote: > > Dear Paul > > Have you defined a variable T or F somewhere? > Rather than look to find o

Re: [R] write.xlsx

2017-03-10 Thread Michael Dewey
Dear Paul Have you defined a variable T or F somewhere? Rather than look to find out why not replace T by TRUE and F by FALSE and see if that solves your problem. On 10/03/2017 07:58, Paul Anthony Frontéri wrote: Hey. I am trying to append a sheet to an existing file using write.xlsx, see co

[R] write.xlsx

2017-03-10 Thread Paul Anthony Frontéri
Hey. I am trying to append a sheet to an existing file using write.xlsx, see code under: write.xlsx(x = data1,file = filename,sheetName = "data1", asTable = FALSE, col.names = T,row.names = F,append = F) write.xlsx(x = data2,file = filename,sheetName = "data2", asTable = FALSE, col.names = T,row.

Re: [R] write.xlsx- writing in a single sheet

2016-01-15 Thread Jim Lemon
Hi Mohsen, I can guess two things that you might want. One is to join all of the data in the "CSV" files into a single data frame and then write that to a single XLSX sheet. If the names and data structure of these files are similar enough to "rbind" them, just do this in R and then write the resul

Re: [R] write.xlsx- writing in a single sheet

2016-01-15 Thread Frans Marcelissen
Do you mean that you try to write several dataframes to the same sheet? You have asked this before, and I think it has been said that that is not possible with write.xls. I suppose that you still try to write rows of data of varying length to one sheet. I think that is possible with the lowlevel fu

Re: [R] write.xlsx- writing in a single sheet

2016-01-15 Thread Marc Schwartz
> On Jan 15, 2016, at 8:43 AM, Mohsen Jafarikia wrote: > > Hello all: > > I am having problem writing a few files in a single sheet of excel. It > seems R has problem writing on the same sheet. Maybe there is a command > that I am missing. Here is the code I am using: > > library(xlsx) > > if

[R] write.xlsx- writing in a single sheet

2016-01-15 Thread Mohsen Jafarikia
Hello all: I am having problem writing a few files in a single sheet of excel. It seems R has problem writing on the same sheet. Maybe there is a command that I am missing. Here is the code I am using: library(xlsx) ifn11 <- "A1.xlsx" dat11 <- read.xlsx(ifn11, sheetName="A.csv", header = TRUE)