[R] read.xlsx - write.xlsx: reading/writing numbers as character
jafarikia at gmail.com
Thu Jan 14 17:36:26 CET 2016
Thanks for the comment Jim. There is no blank cell. All have numbers.
On Thu, Jan 14, 2016 at 11:29 AM, jim holtman <jholtman at 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 <jafarikia at gmail.com>
>> 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!
>> [[alternative HTML version deleted]]
>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> PLEASE do read the posting guide
>> and provide commented, minimal, self-contained, reproducible code.
[[alternative HTML version deleted]]
More information about the R-help