[R] excel files and R

[Simon Fear]

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}}