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