Thanks for the comment Jim. There is no blank cell. All have numbers. Mohsen
On Thu, Jan 14, 2016 at 11:29 AM, jim holtman <jholt...@gmail.com> wrote: > Take a look at the data coming in since you may have something that looks > like characters (maybe 'blanks'). What you think is numeric in EXCEL might > not be. > > > Jim Holtman > Data Munger Guru > > What is the problem that you are trying to solve? > Tell me what you want to do, not how you want to do it. > > On Thu, Jan 14, 2016 at 11:20 AM, Mohsen Jafarikia <jafari...@gmail.com> > wrote: > >> Hello: >> >> I am reading some excel files (each with one sheet) and trying to write >> them all in one file. I am not sure if read.xlsx reads some of the columns >> as character or write.xlsx writes them as character where they are not >> characters. I have 12 columns (2 character and 10 numbers). From 10 number >> columns, with float and integer numbers, only 3 of them are recognized >> correctly. I was wondering how can I define the the column format for >> read.xlsx - write.xlsx. >> >> Here comes a simple example of my code: >> >> ifn1 <- "A.xlsx" >> dat1 <- read.xlsx(ifn1, sheetName="A.csv", header = TRUE) >> >> ifn2 <- "F.xlsx" >> dat2 <- read.xlsx(ifn2, sheetName="F.csv",header = TRUE) >> >> write.xlsx(dat1, file="AF.xlsx", sheetName="A", showNA=FALSE, >> row.names=FALSE, append=FALSE) >> write.xlsx(dat2, file="AF.xlsx", sheetName="F", showNA=FALSE, >> row.names=FALSE, append= TRUE) >> >> Thanks in advance! >> Mohsen >> >> [[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. >> > > [[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.
