>
> 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]]

