Re: [R] Excel calling R functions

From: Alberto Monteiro <>
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 mailing list PLEASE do read the posting guide 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 Please read the posting guide before posting to the list.