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)