Re: [R] reading data from Excel Spread sheet

2009-01-17 Thread Liviu Andronic
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

Re: [R] reading data from Excel Spread sheet

2009-01-17 Thread Gabor Grothendieck
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)?

[R] reading data from Excel Spread sheet

2009-01-16 Thread venkata kirankumar
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

Re: [R] reading data from Excel Spread sheet

2009-01-16 Thread Thomas Schwander
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

Re: [R] reading data from Excel Spread sheet

2009-01-16 Thread Prof Brian Ripley
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

Re: [R] reading data from Excel Spread sheet

2009-01-16 Thread John Sorkin
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

Re: [R] reading data from Excel Spread sheet

2009-01-16 Thread Pedro Mardones
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