Sorry but I was interested in reading as date format from the excel itself. Is there any way of doing this?
Regards Utkarsh -----Original Message----- From: Gabor Grothendieck [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 8:43 PM To: Utkarsh Singhal Cc: [EMAIL PROTECTED] Subject: Re: [R] reading Excel file If d is the number of days since the Epoch then now <- Sys.Date() now - julian(now) + d will give you a "Date" class variable. There is some info on dates in R News 4/1. On Tue, Mar 25, 2008 at 10:00 AM, Utkarsh Singhal <[EMAIL PROTECTED]> wrote: > Hi R, > > > > I have an excel file in which the third column is "date" and others are > "character" and "numeric". > > Number of columns are 12 > > > > If I use this to read the file in R: x = read.xls("D:\\file.xls") > > > > The problem is that my date column is read in julian dates. > > > > So I am using: x = read.xls("D:\\file.xls", > colClasses= c(rep("character",2),"isodate",rep("character",9))) > > > > But what can I do in case I don't know the number of columns in my > file?? > > > > I mean is there any way I can specify the colClass of only third column > and for other columns it can take the default classes?? > > > > > > Regards > > Utkarsh > > > > > > This e-mail may contain confidential and/or privileged i...{{dropped:13}} > > ______________________________________________ > R-help@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. > This e-mail may contain confidential and/or privileged i...{{dropped:13}} ______________________________________________ R-help@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.
