[R] MS Excel Data

[Bert Gunter]

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.
http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html  provides
some details.

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.


Bert Gunter
Genentech Nonclinical Statistics

-----Original Message-----
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.
Good luck
AA.

----- 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.
>
> Regds
> Faisal Afzal SIddiqui
> +92-300-9297089
> fasidfas at yahoo.com
>
>
> 
>
____________________________________________________________________________
________
> Never miss a thing.  Make Yahoo your home page.
>
> ______________________________________________
> R-help at 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 at 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.