Skip to content
Back to formatted view

Raw Message

Message-ID: <Pine.LNX.4.44.0401260731090.27955-100000@gannet.stats>
Date: 2004-01-26T07:41:37Z
From: Brian Ripley
Subject: D(COM) with Excel
In-Reply-To: <003101c3e3c7$054f5c70$2a01a8c0@extropy>

On Mon, 26 Jan 2004, Joel Pitt wrote:

> Hi there,
> 
> I'm currently trying to use R in an automated
> macro with Excel, and to this effect I've been
> using the D(COM) server.
> 
> However I've been having alot of problems with
> it, because it seems to be limited to only recieving
> and sending arrays. I've been struggling
> trying to find a way to receive model summaries
> from R to put in Excel. I also seem to have
> some strange errors coming up...
> I've tried doing everything I want directly in R
> by hand, and it has been fine, but excel seems to
> complicate everything :(
> 
> Any people have suggestions?

There are two (D)COM servers for R, on by Thomas Baier that has its own 
mailing list, and one by Duncan Temple Lang (at www.omegahat.org and in 
the Omegahat area on CRAN).

It is impossible for us to help with a message as vague as `some strange
errors coming up', so I suggest you read

http://www.chiark.greenend.org.uk/~sgtatham/bugs.html

and then post on the appropriate mailing list for whichever server you are 
using.

[The Baier-version list is listed at the bottom of its readme.txt file.]

-- 
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