[R] Excel calling R functions
Horace.Tso at pgn.com
Fri Jun 1 22:47:50 CEST 2007
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.
>>> 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:
> 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.
> See the Excel heading for your question. You might be
> interested as well by the recent OpenOffice.org plugin
> (heading OOo).
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