 

Sorry but I was interested in reading as date format from the excel
itself. Is there any way of doing this?

 

Regards

Utkarsh

 

 

 

-----Original Message-----
From: Gabor Grothendieck [mailto:ggrothendieck@gmail.com] 
Sent: Tuesday, March 25, 2008 8:43 PM
To: Utkarsh Singhal
Cc: r-help@stat.math.ethz.ch
Subject: Re: [R] reading Excel file

 

If d is the number of days since the Epoch then

 

now <- Sys.Date()

now - julian(now) + d

 

will give you a "Date" class variable.  There is some info on dates in

R News 4/1.

 

On Tue, Mar 25, 2008 at 10:00 AM, Utkarsh Singhal

<utkarshs@ambaresearch.com> wrote:

> Hi R,

> 

> 

> 

> I have an excel file in which the third column is "date" and others
are

> "character" and "numeric".

> 

> Number of columns are 12

> 

> 

> 

> If I use this to read the file in R:   x = read.xls("D:\\file.xls")

> 

> 

> 

> The problem is that my date column is read in julian dates.

> 

> 

> 

> So I am using:                           x = read.xls("D:\\file.xls",

> colClasses= c(rep("character",2),"isodate",rep("character",9)))

> 

> 

> 

> But what can I do in case I don't know the number of columns in my

> file??

> 

> 

> 

> I mean is there any way I can specify the colClass of only third
column

> and for other columns it can take the default classes??

> 

> 

> 

> 

> 

> Regards

> 

> Utkarsh

> 

> 

> 

> 

> 

> This e-mail may contain confidential and/or privileged
i...{{dropped:13}}

> 

> ______________________________________________

> R-help@r-project.org mailing list

> 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.

> 

This e-mail may contain confidential and/or privileged i...{{dropped:13}}

