R help - Oct 2007 - Read in date fomat while colClasses="character"

Hi R users,

 

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

Now is there someway I can read in date format while keeping
colClasses="character"

 

Thanks for your help

 

Ravi 


	[[alternative HTML version deleted]]

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