There are many answers to this in R but some considerations are - what platform are you using? - do you have access to Excel or only to the spreadsheet itself? If you have access to Excel is it on the same machine as R? - is it an Excel 2003 spreadsheet (.xls) or Excel 2007 spreadsheet (.xlsx)? - is this a one time transfer of a particular data set or will you be transferring numerous similar spreadsheets? - is the spreadsheet located on your computer or does it have to be fetched from the internet or some other place?
On Fri, Jan 16, 2009 at 4:32 AM, venkata kirankumar <kiran4u2...@gmail.com> wrote: > Hi all, > > I tried to read data from Excel spread sheet with using > > read.csv(file.choose()) > and > read.delim(file.choose()) > but its showing " *ÐÏ.à.*." > > and also i tried with > read.table(file.choose()) > > then its showing " * V1 > 1 ÐÏ\021ࡱ* " > > > can any one suggest how to read data from Excel Spread sheet > > thanks & regards; > > kiran > > [[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. > > ______________________________________________ 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.
