[R] reading dates in Excel into R

Peter Alspach Peter.Alspach at plantandfood.co.nz
Thu Jul 29 23:18:37 CEST 2010


Tena koe

What do you want to control?  You can govern the format used in R using the appropriate R functions.  I doubt it would be useful to have dates read from Excel depend on the format set for displaying those dates in Excel.

HTH ....

Peter Alspach

> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> project.org] On Behalf Of Hongying Li
> Sent: Friday, 30 July 2010 5:33 a.m.
> To: r-help at r-project.org
> Subject: [R] reading dates in Excel into R
> 
> 
> I am reading dates in Excel2007 into R.
> 
> Here are the functions I used:
> 
> library(RODBC)
> channel<-odbcConnectExcel2007("myfile.xlsx")
> tmp<-sqlFetch(channel,"1",as.is=T)
> 
> 
> The dates in myfile.xlsx are all in this format: mm/dd/yyyy. But when I
> read it to R, some columns look like "yyyy-mm-dd 00:00:00", some
> columns look like "yyyy-mm-dd", and some columns are numbers. I do not
> know how I can control this.
> 
> 
> 
> Any help? Thanks!
> 
> 
> 
> _________________________________________________________________
> Hotmail is redefining busy with tools for the New Busy. Get more from
> your inbox.
> 
> N:WL:en-US:WM_HMP:042010_2
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> 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.



More information about the R-help mailing list