[R] reading dates in Excel into R

Erich Neuwirth erich.neuwirth at univie.ac.at
Mon Aug 2 16:43:18 CEST 2010


RExcel (available as an Excel Addin in Windows only) tries very hard
to transfer dates and times faithfully to R.
The package RExcelInstaller on CRAN will install it.


On Jul 29, 2010, at 7:32 PM, Hongying Li wrote:

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

--
Erich Neuwirth, University of Vienna
Faculty of Computer Science
Center for Computer Science Didactics and Learning Research 
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-39902 Fax: +43-1-4277-39459



More information about the R-help mailing list