Re: [R] Excel calling R functions

From: Duncan Temple Lang <dtemplelang_at_ucdavis.edu>
Date: Fri, 01 Jun 2007 11:27:35 -0700

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

______________________________________________
R-help_at_stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Fri 01 Jun 2007 - 18:36:19 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 Fri 01 Jun 2007 - 21:32:09 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.