[R-SIG-Finance] Passing dates from Excel to R using RExcel functions
kriskumar at earthlink.net
Thu Sep 14 02:40:09 CEST 2006
I have had no problems passing date in as dataframes back and forth and
is now my prefered method.. No need to even do as.Date or know
all the Posixct kungfu although it is worth knowing all that..
[Instead of rput I use rputdataframe and this works like a charm with
zoo or the new Diethelm's timeSeries class .]
Gabor Grothendieck wrote:
>There is some discussion of Excel dates in the R Help article
>in R News 4/1.
>On 9/11/06, Paolo Rossi <prossi79.r at gmail.com> wrote:
>>Good morning all,
>>I have the following problem using RExcel. When I use the VBA function
>>"putarray" to put a vector of dates from Excel to R, I don't see the dates
>>in R but the serial number converted to text. I don't know, then, how to
>>trasform them in dates again...
>>could anyone help me?
>>thank you very much
>> [[alternative HTML version deleted]]
>>R-SIG-Finance at stat.math.ethz.ch mailing list
>R-SIG-Finance at stat.math.ethz.ch mailing list
More information about the R-SIG-Finance