>
> I am using xlsReadWrite to read a particular excel file. In one of the
> columns I have dates ( say col=5). Now date column is read by default as
> numeric. So I used dateTimeAs= "isodatetime". This enables reading in
> the date format.
dateTimeAs= "isodatetime" reads and converts the dates into a character
representation. You could also read the dates as numeric values and convert
them later to strings with the functions "dateTimeToStr" or
"dateTimeToIsoStr".
However in the earlier column (say col=1) I have data
> which however starts from row 10. So to read data from column one I use
> colClasses="character". But this overrules the isodatetime.
another possibility would be to give a vector for the colClasses argument,
e.g.
colClasses = c( "character", "character", "double", "double",
"isodatetime" )
--
Regards,
Hans-Peter
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
