Re: [R] reading Excel file

From: Utkarsh Singhal <utkarshs_at_ambaresearch.com>
Date: Wed, 26 Mar 2008 10:11:36 +0530

 

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_at_gmail.com] Sent: Tuesday, March 25, 2008 8:43 PM
To: Utkarsh Singhal
Cc: r-help_at_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_at_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_at_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}}



R-help_at_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. Received on Wed 26 Mar 2008 - 04:49:28 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 26 Mar 2008 - 11:30:27 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive