[R] how to import data from excel to R

Charlie Sharpsteen chuck at sharpsteen.net
Thu Dec 17 21:07:25 CET 2009


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




More information about the R-help mailing list