[R] Excel calling R functions

Duncan Temple Lang dtemplelang at ucdavis.edu
Fri Jun 1 20:27:35 CEST 2007

And just for completeness for the thread,
there is the RDCOMServer package which has
a more general mechanism for making R
functionality available to other applications
that does not require writing R commands
but uses the language independent spirit of
DCOM.  And it also allows event handlers
for things like Excel actions to be written as R functions

Tobias Verbeke wrote:
> Marc Schwartz wrote:
>> On Fri, 2007-06-01 at 08:50 -0700, Horace Tso wrote:
>>> Hi folks,
>>> Is it possible to have Excel call a R function. If not, how about
>>> making Excel send off a command to call a R script and then read the
>>> result back into Excel.
>>> I know, I know, this should belong to some Excel forum, but i just try
>>> my luck here.
>>> Thanks in advance.
>>> Horace W. Tso
>> See the R-Excel add-in linked from here:
>>   http://www.sciviews.org/_rgui/projects/RDcom.html
> Some of the files listed in the link on that page appear
> to be quite outdated. The following link brings you to
> the current portal of the R(D)COM server and the
> rcom package.
> http://sunsite.univie.ac.at/rcom/
> See the Excel heading for your question. You might be
> interested as well by the recent OpenOffice.org plugin
> (heading OOo).
> HTH,
> Tobias

Duncan Temple Lang                duncan at wald.ucdavis.edu
Department of Statistics          work:  (530) 752-4782
4210 Mathematical Sciences Bldg.  fax:   (530) 752-7099
One Shields Ave.
University of California at Davis
Davis, CA 95616, USA

More information about the R-help mailing list