Re: [R] Excel calling R functions

From: Alberto Monteiro <albmont_at_centroin.com.br>
Date: Fri, 01 Jun 2007 15:49:16 -0200

Horace Tso wrote:
>
> 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.
>
You can always put R in loop, checking each second or minute for the _existence_ of a file. As soon as this file is create, run an R function, and output a file.

Then, do the same in Excel: write a file (I _think_ this is possible with macros), enter into a loop waiting for the other file to be created, and procceed after that.

Slow, but better than to use Excel alone :-)

Alberto Monteiro



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 - 17:58:28 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 - 19:31:34 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.