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
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)?
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
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
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
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
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
7 matches
Mail list logo