Re: [R] reading data from Excel Spread sheet
On 1/16/09, venkata kirankumar kiran4u2...@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 __ 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.
Re: [R] reading data from Excel Spread sheet
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.
[R] reading data from Excel Spread sheet
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.
Re: [R] reading data from Excel Spread sheet
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@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.
Re: [R] reading data from Excel Spread sheet
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, rip...@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, UKFax: +44 1865 272595__ 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.
Re: [R] reading data from Excel Spread sheet
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 kiran4u2...@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}}
__
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.
Re: [R] reading data from Excel Spread sheet
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 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.
