Displaying 1 result from an estimated 1 matches for "readseries".
Did you mean:
leadseries
2010 Jul 29
4
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