Displaying 7 results from an estimated 7 matches for "a_col".
Did you mean:
n_col
2017 Sep 24
0
"XLConnect" packages; Excel dates read incorrectly
Hi John,
I was able to reproduce your problem in my environment.
I modified the statement
date11<-as.Date(a_col$date, format="%Y-%m-%d")
to
date11<-as.Date(as.POSIXlt(a_col$date),format="%Y-%m-%d")
which then gives the output you would like to see (at least on my system)
> date11
[1] "2004-01-01" "2004-01-02" "2004-01-05" "2004-01-06" "2...
2017 Sep 24
3
"XLConnect" packages; Excel dates read incorrectly
...t;>
> >>> fl<-paste("allData_out3.xlsx")
> >>> a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric")
> >>> b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric")
> >>> a_col<-readWorksheetFromFile(fl, sheet="first")
> >>> date11<-as.Date(a_col$date, format="%Y-%m-%d")
> >>>
> >>>
> >>> The output:
> >>>> date11
> >>> [1] "2003-12-31" "2004-01-01" &qu...
2017 Sep 23
2
"XLConnect" packages; Excel dates read incorrectly
...e codes are (also attached):
rm(list=ls())
library(XLConnect)
library(xlsx)
fl<-paste("allData_out3.xlsx")
a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric")
b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric")
a_col<-readWorksheetFromFile(fl, sheet="first")
date11<-as.Date(a_col$date, format="%Y-%m-%d")
The output:
> date11
[1] "2003-12-31" "2004-01-01" "2004-01-04" "2004-01-05" "2004-01-06"
"2004-01-07"
[7] "2004...
2017 Sep 23
0
"XLConnect" packages; Excel dates read incorrectly
...list=ls())
> library(XLConnect)
> library(xlsx)
>
> fl<-paste("allData_out3.xlsx")
> a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric")
> b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric")
> a_col<-readWorksheetFromFile(fl, sheet="first")
> date11<-as.Date(a_col$date, format="%Y-%m-%d")
>
>
> The output:
>> date11
> [1] "2003-12-31" "2004-01-01" "2004-01-04" "2004-01-05" "2004-01-06"
> "...
2017 Sep 23
2
"XLConnect" packages; Excel dates read incorrectly
...ect)
> > library(xlsx)
> >
> > fl<-paste("allData_out3.xlsx")
> > a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric")
> > b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric")
> > a_col<-readWorksheetFromFile(fl, sheet="first")
> > date11<-as.Date(a_col$date, format="%Y-%m-%d")
> >
> >
> > The output:
> >> date11
> > [1] "2003-12-31" "2004-01-01" "2004-01-04" "2004-01-05" &quo...
2017 Sep 24
0
"XLConnect" packages; Excel dates read incorrectly
...ibrary(xlsx)
>>>
>>> fl<-paste("allData_out3.xlsx")
>>> a1<-readWorksheetFromFile(fl, sheet="first", colTypes="numeric")
>>> b1<-readWorksheetFromFile(fl, sheet="second", colTypes="numeric")
>>> a_col<-readWorksheetFromFile(fl, sheet="first")
>>> date11<-as.Date(a_col$date, format="%Y-%m-%d")
>>>
>>>
>>> The output:
>>>> date11
>>> [1] "2003-12-31" "2004-01-01" "2004-01-04" "20...
2007 Mar 19
24
alias method spec?
I am completely baffled by this one - My guess is that there is no
pure ruby way to do this - but how could I set up a spec to test that
one method is an alias of another?
Thanks for any help,
Scott