Re: [R] reading Excel file

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Tue, 25 Mar 2008 13:28:10 -0400

You can convert the days to Date class after reading it in. See R News 4/1.

On Tue, Mar 25, 2008 at 10:00 AM, Utkarsh Singhal <utkarshs_at_ambaresearch.com> 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_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.
>



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 Tue 25 Mar 2008 - 18:46:18 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 Tue 25 Mar 2008 - 20: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