Re: [R] reading Excel file

From: jim holtman <jholtman_at_gmail.com>
Date: Wed, 26 Mar 2008 06:06:11 -0500

If you want to read in the numeric values from EXCEL and the use them, here is a function I use to go the other way -- take a POSIXct value and convert it to what EXCEL wants. So you can just write the inverse of this function:

unix2EXCEL <- function (time) time/86400 + 25569

On Tue, Mar 25, 2008 at 11:41 PM, Utkarsh Singhal <utkarshs_at_ambaresearch.com> wrote:
>
>
> 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.
>

-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem you are trying to solve?

______________________________________________
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 - 11:11:04 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 - 15:30:24 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