[R] MS Excel Data
gunter.berton at gene.com
Thu Nov 29 21:01:21 CET 2007
This has been discussed on this list many times before. Google on "Import
Excel R". Note also that there are potential problems (loss of digits) due
to Excel "idiosyncracies" depending on what you do.
Finally, I have found that for rectangular data sets with no missing fields
in Excel (tables), cutting and read.tabling **the data only ** is a
simple(but probably not without risk) way to do it:
(after cutting the data only in Excel to the clipboard) in R:
newdat <- read.table("clipboard", head=FALSE, row.names=NULL)
The columns can then be named via names(newdat) <- ...
I omit column headers because in most of the Excel data I get the column
names have spaces and other non-alphanumeric characters which R cannot
easily digest. One could separately scan() just the vector of column headers
and use regular expressions to extract the names. But for small tables, I
find it easier just to create the names manually.
Genentech Nonclinical Statistics
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On
Behalf Of AA
Sent: Thursday, November 29, 2007 10:30 AM
To: faisal afzal siddiqui; r-help at r-project.org
Subject: Re: [R] MS Excel Data
The package RODBC by Pr. Ripley is very helpful for this
(Thanks To B. Ripley).
Also see the package xlsReadWrite (thanks to H.P Suter).
The latter is maybe easier to use.
----- Original Message -----
From: "faisal afzal siddiqui" <fasidfas at yahoo.com>
To: <r-help at r-project.org>
Sent: Wednesday, November 28, 2007 10:54 PM
Subject: [R] MS Excel Data
>I am using MS Excel (Windos Operating system), how I
> import/export data between MS_Excel and R.
> Faisal Afzal SIddiqui
> fasidfas at yahoo.com
> Never miss a thing. Make Yahoo your home page.
> R-help at r-project.org mailing list
> PLEASE do read the posting guide
> and provide commented, minimal, self-contained, reproducible code.
R-help at r-project.org mailing list
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
More information about the R-help