[R] how to import data from excel to R

Gabor Grothendieck ggrothendieck at gmail.com
Thu Dec 17 20:18:00 CET 2009


Check out these notes:

http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows

and note that within quotes you must double each backslash so one
writes "c:\\mydirectory\\abc.xls" for example.

On Thu, Dec 17, 2009 at 12:24 PM,  <sta_2279 at spectrum.net.in> wrote:
> Hi,
>   I am using R and I want to know how data can be transferred from Excel
> Spread sheet to R for analyzing. I have done like this
>
> mydata<-read.table("C:\Documents and Settings\admin\Desktop\data.txt");
>
>
> but its not working how can i do it
>
>                                                      regards
>
>                                                    Sarath Sankar V
>                                               Spectrum Softtech Solution
>
> ______________________________________________
> 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.
>




More information about the R-help mailing list