Hey, If you want to read it in as a text file, make sure to have Excel save it as a text file first. For instance, a tab delimited text file. Then you could read it in with
mydata <- read.table("myfile.txt", sep="\t") HTH, Josh 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 > > regards > > Sarath Sankar V > Spectrum Softtech Solution > > ______________________________________________ > 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<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. > -- Joshua Wiley Senior in Psychology University of California, Riverside http://www.joshuawiley.com/ [[alternative HTML version deleted]] ______________________________________________ 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.