[R] excel files and R

[partha_bagchi@hgsi.com]

Simon,

Here is what I do when I encounter an excel spreadsheet. I save it as a 
CSV file (in excel -> save as -> file type CSV) and then read the 
corresponding file into R using read.csv.

Hope that helps,
Partha





"Simon Fear" <Simon.Fear at synequanon.com>
Sent by: r-help-bounces at stat.math.ethz.ch
06/25/2003 06:16 AM

 
        To:     "Erich Neuwirth" <erich.neuwirth at univie.ac.at>
        cc:     r-help at stat.math.ethz.ch
        Subject:        RE: [R] excel files and R


Many many thanks. I did look at this but I have absolutely no idea of
the
background so got completely lost. Can you recommend a gentle
introduction/overview to this area, based on the assumption that my
current
knowledge equals zero? Indeed, could you make an argument that I should
ever
*want* to run R from within Excel or vice versa? I think I just want to
get
the data from Excel ('cos that's how it nearly always comes), but I
don't
want to process it in Excel, when I have R ...

I guess all that I and apparently others really want is that "foreign"
might
include read.excel, like it has read.sas and read.spss. Which is
essentially
what Bernhard Pfaff's recent post offers - thanks again Bernhard - but
using
RODBC instead of foreign.


-----Original Message-----
From: Erich Neuwirth [mailto:erich.neuwirth at univie.ac.at]
Sent: 25 June 2003 10:42
To: Morrison, Gordon; r-help at stat.math.ethz.ch
Subject: Re: [R] excel files and R

And there is Thomas Baier's and my RCOM package
which would allow to run R from within Excel
or exchange data between Excel and R with R
as the main interface.


Morrison, Gordon wrote:
> If you really want to run windows from R (in my experience it is much
better
> to reside entirely within R) then I think that you need to use Duncan
Temple
> Lang's RDCOM package ( http://www.omegahat.org/ ). It works well and
> robustly for connections to other packages and I have tested it for
Excel.

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help


Simon Fear
Senior Statistician
Syne qua non Ltd
Tel: +44 (0) 1379 644449
Fax: +44 (0) 1379 644445
email: Simon.Fear at synequanon.com
web: http://www.synequanon.com

Number of attachments included with this message: 0

This message (and any associated files) is confidential and\...{{dropped}}

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.