Re: [R] odbcConnectExcel2007

From: Prof Brian Ripley <>
Date: Mon, 03 Nov 2008 07:33:44 +0000 (GMT)

On Tue, 28 Oct 2008, Agnolucci, Paolo wrote:

> Hi
> sorry if this is really basic but I am just starting on R.
> Can anyone point me at how to write R objects into Excel 2007 files. I
> have seen how to set up a connection to a file through
> odbcConnectExcel2007(xls.file, readOnly = FALSE, ...) but it doesn't say
> anything on how to write data

See sqlWrite in the RODBC (the uncredited package here) documentation. See also the examples in the installed tests.R file.

Brian D. Ripley,        
Professor of Applied Statistics,
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________ mailing list
PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.
Received on Mon 03 Nov 2008 - 07:39:07 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 03 Nov 2008 - 08:30:21 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive