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