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]]
Hi, http://tolstoy.newcastle.edu.au/R/e2/help/06/12/6702.html Cheers, Thomas venkata kirankumar schrieb:> 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 at 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. >
See the 'R Data Import/Export' manual (and please study the posting guide, which asked you to check the manuals before posting). On Fri, 16 Jan 2009, venkata kirankumar 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]] > >-- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
Kiran, One, not very elegant way, to solve your problem is to first save the Excel spreadsheet as a CSV file (open the Excel file in Excel and the use file->save as CSV, i.e. xxx.CSV) and then use read.csv() John John David Sorkin M.D., Ph.D. Chief, Biostatistics and Informatics University of Maryland School of Medicine Division of Gerontology Baltimore VA Medical Center 10 North Greene Street GRECC (BT/18/GR) Baltimore, MD 21201-1524 (Phone) 410-605-7119 (Fax) 410-605-7913 (Please call phone number above prior to faxing)>>> "venkata kirankumar" <kiran4u2all at gmail.com> 1/16/2009 4:32 AM >>>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]] Confidentiality Statement: This email message, including any attachments, is for th...{{dropped:6}}
....or maybe by using the xlsReadWrite package:
mydata <- read.xls("mydata.xls", sheet = 'Sheet1")
On Fri, Jan 16, 2009 at 4:32 AM, venkata kirankumar
<kiran4u2all at 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 at 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.
>
>
On 1/16/09, venkata kirankumar <kiran4u2all at gmail.com> wrote:> can any one suggest how to read data from Excel Spread sheet >Perhaps easiest alternative for Excel users: RExcel [1]. I would suggest to use this bundle installer [2]. When in Excel with RExcel loaded, select your data in Excel and choose "Put R Dataframe". Liviu [1] http://sunsite.univie.ac.at/rcom/ [2] http://sunsite.univie.ac.at/rcom/download/RAndFriends.distro/RAndFriendsLightSetup2081V3.0-8-1.exe -- Do you know how to read? http://www.alienetworks.com/srtest.cfm Do you know how to write? http://garbl.home.comcast.net/~garbl/stylemanual/e.htm#e-mail
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 <kiran4u2all at 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 at 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. > >