[R] how to import data from excel to R

[Charlie Sharpsteen]

On Thu, Dec 17, 2009 at 9:24 AM, <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


The "R Data Import/Export" manual covers this topic in general:

  http://cran.r-project.org/doc/manuals/R-data.html

Chapter 8 concerns getting data into and out of excel.  This post on
the Learning R blog also covers many available options for importing
directly from Excel files:

  http://learnr.wordpress.com/2009/10/06/export-data-frames-to-multi-worksheet-excel-file/

Hope this helps!

-Charlie