[R] excel files and R

[Morrison, Gordon]

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. 


Regards,


Gordon Morrison
Global Head of Quantitative Research

> *	+ 44 20 7653 7642
> Mob:     + 44 7867 801951
> fax:	+ 44 20 7645 7442
> * 	mailto:gordon.morrison at commerzbankib.com
> web:	http://www.cbksec.com/rsh/portfolio&risk.html
> *	Commerzbank Securities
> 	60 Gracechurch Street
>                 London EC3V 0HR, U.K.
> 


-----Original Message-----
From: Simon Fear [mailto:Simon.Fear at synequanon.com]
Sent: 25 June 2003 09:22
To: r-help at stat.math.ethz.ch
Subject: RE: [R] excel files and R


RODBC works fine but as far as I can tell requires that the connection
be
opened through Windows menus. OK for a one-off, but not for batch
processing.
Please someone tell me what I missed - how can I open the connection
within
an R script?
(Windows 98)(not my fault)

TIA
 (sorry for long disclaimer, can't switch it off)

-----Original Message-----
From: Prof Brian Ripley [mailto:ripley at stats.ox.ac.uk]
Sent: 24 June 2003 17:54
To: Victor H. Marím
Cc: r-help at stat.math.ethz.ch
Subject: Re: [R] excel files and R


Security Warning:
If you are not sure an attachment is safe to open please contact 
Andy on x234. There are 0 attachments with this message.
________________________________________________________________

On Tue, 24 Jun 2003, Victor H. Marím wrote:

> I am new at R.  My questions is rather basic.  Looking R manuals looks
> like there should be a way to read MS excel files into R.  Could
> somebody tell me which library should I use for that?

Several ways are in the R Data Import/Export Manual (the obvious manual,
I
would have thought).  If you are working on Windows, using RODBC is
perhaps the simplest.

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________
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\ con...
{{dropped}}

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


********************************************************************** 
This is a commercial communication from Commerzbank AG.

This communication is confidential and is intended only for the person to
whom it is addressed.  If you are not that person you are not permitted to
make use of the information and you are requested to notify
<mailto:LONIB.Postmaster at commerzbankib.com> immediately that you have
received it and then destroy the copy in your possession.

Commerzbank AG may monitor outgoing and incoming e-mails. By replying to
this e-mail you consent to such monitoring. This e-mail message and any
attached files have been scanned for the presence of computer viruses.
However, you are advised that you open attachments at your own risk.

This email was sent either by Commerzbank AG, London Branch, or by
Commerzbank Securities, a division of Commerzbank.  Commerzbank AG is a
limited liability company incorporated in the Federal Republic of Germany.
Registered Company Number in England BR001025. Our registered address in
the UK is 23 Austin Friars, London, EC2P 2JD. We are regulated by the
Financial Services Authority for the conduct of investment business in the
UK and we appear on the FSA register under number 124920.