I have to remove the dollar sign from the end of the sheet names.
>
> >
> > 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
>
[[alternative HTML version deleted]]
______________________________________________
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
