[R] Read ".xlsx" and convert date-column value into Dataframe

[Ivan Calandra]

Hi Antony,

Except if you have good reasons to use R2.15, it is generally a good 
idea to upgrade to the latest version.
In any case, the solutions that were proposed on the list will 
definitely work fine.

There are however advantages of using readxl, in my opinion. readxl does 
not use dependencies; it correctly converts to dates; and if you have 
empty cells in numeric columns, xlsx will convert to NaN and not NA as 
would be expected (correct me if this behavior has been modified in the 
latest version). The problem with readxl is that it only reads! A 
similar write function would be nice!

Ivan

--
Ivan Calandra, ATER
University of Reims Champagne-Ardenne
GEGENAA - EA 3795
CREA - 2 esplanade Roland Garros
51100 Reims, France
+33(0)3 26 77 36 89
ivan.calandra at univ-reims.fr
https://www.researchgate.net/profile/Ivan_Calandra

Le 23/07/15 08:50, R_Antony a écrit :
> Hi Ivan,
>
> This way i would've tried but i am using R 2.15 - ReadXL package will
> support R >=3 versions.
>
> Thanks,
> Antony.
>
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Read-xlsx-and-convert-date-column-value-into-Dataframe-tp4710192p4710232.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
>