[R] Excel calling R functions

[Horace Tso]

Thanks to Marc, Duncan, Tobias, Alberto. I'm aware of rcom and have in fact downloaded it somewhere. But unfortunately it won't work for me as I'm in a corporate environment and don't have admin rights to set up the R(D)COM (background) server. If there is a way to work around it, pls let me know.

Horace

 

>>> Duncan Temple Lang <dtemplelang at ucdavis.edu> 6/1/2007 11:27:35 AM >>>
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