excel files and R
There's a function odbcConnectExcel, a wrapper to odbcDriverConnect. Neither require any work with Windows menus.
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: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