[R] read.xlsx - write.xlsx: reading/writing numbers as character
jafarikia at gmail.com
Thu Jan 14 18:59:49 CET 2016
It looks okay on CSV too.
On Thu, Jan 14, 2016 at 12:17 PM, Jim Holtman <jholtman at gmail.com> wrote:
> Write it out as a csv from excel and see what the data looks like. That
> may help in seeing what the problem is.
> Sent from my Verizon Wireless 4G LTE Smartphone
> -------- Original message --------
> From: Mohsen Jafarikia
> Date:01/14/2016 11:36 (GMT-05:00)
> To: jim holtman
> Cc: r-help
> Subject: Re: [R] read.xlsx - write.xlsx: reading/writing numbers as
> 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
>>> 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
>>> 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