>
> There's a function odbcConnectExcel, a wrapper to odbcDriverConnect.
> Neither require any work with Windows menus.
>
Try the following sample script and save it as "foo.R":
library(RODBC)
chan1 <- odbcConnectExcel("your-file.xls")
aa <- sqlFetch(chan1, "Name of your sheet")
names(aa)
close(chan1)
as batch:
Rterm --no-restore --no-save < foo.R
works for me, at least.
HTH,
Bernhard
> On Wed, 25 Jun 2003, Simon Fear wrote:
>
> > 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:[EMAIL PROTECTED]
> > Sent: 24 June 2003 17:54
> > To: Victor H. Marím
> > Cc: [EMAIL PROTECTED]
> > 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, [EMAIL PROTECTED]
> 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
>
> ______________________________________________
> [EMAIL PROTECTED] mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
>
----------------------------------------------------------------------
If you have received this e-mail in error or wish to read our e-mail
disclaimer statement and monitoring policy, please refer to
http://www.drkw.com/disc/email/ or contact the sender.
______________________________________________
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
