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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of AA
Sent: Thursday, November 29, 2007 10:30 AM
To: faisal afzal siddiqui; r-help@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" <[EMAIL PROTECTED]>
To: <r-help@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
> [EMAIL PROTECTED]
>
>
>
>
____________________________________________________________________________
________
> Never miss a thing. Make Yahoo your home page.
>
> ______________________________________________
> R-help@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@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@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.
