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)?
-
On 1/16/09, venkata kirankumar 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 Datafram
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
wrote:
> Hi all,
>
> I tried to read data from Excel spread sheet with using
>
> read.csv(file.choose())
> and
> read.delim(file.choose())
> but
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 Mary
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()
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
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
7 matches
Mail list logo
