Re: [R] reading Excel file

From: Hans-Peter <gchappi_at_gmail.com>
Date: Wed, 26 Mar 2008 15:44:00 +0100

yet another possibility...

if you look at 'help(package=xlsReadWrite)' you'll find a function
'dateTimeToStr' by which you can convert your date-numbers from column 3
into a string. Something along (untested):

myRead <- function( fn ) {
  dat <- read.xls( file = fn, dateTimeAs = "numeric" )   dat[,3] <- dateTimeToStr( dat[,3] ) # or any other conversion function   dat
}

'dateTimeAs' argument is (probably) needed to retrieve plain numbers and
override the default conversion to date string.

-- 
Regards,
Hans-Peter

	[[alternative HTML version deleted]]

______________________________________________
R-help_at_r-project.org 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.
Received on Wed 26 Mar 2008 - 14:45:55 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 26 Mar 2008 - 15:30:24 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive