[R] Excel calling R functions

[Horace Tso]

Charles, thanks for the thought. In my case that's quite impractical/impossible because I'm working from a monstrous spreadsheet having dozens of sheets and numerous links. In some way that's the irreplaceable aspect of a spreadsheet program like Excel. 

H.

>>> "Charles Annis, P.E." <Charles.Annis at StatisticalEngineering.com> 6/1/2007 9:03:20 AM >>>
You might consider having R do everything:  R can read the Excel sheet, do
what needs to be done, and write the results to an Excel sheet.  



Charles Annis, P.E.

Charles.Annis at StatisticalEngineering.com 
phone: 561-352-9699
eFax:  614-455-3265
http://www.StatisticalEngineering.com 
 

-----Original Message-----
From: r-help-bounces at stat.math.ethz.ch 
[mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Horace Tso
Sent: Friday, June 01, 2007 11:51 AM
To: r-help at stat.math.ethz.ch 
Subject: [R] Excel calling R functions

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

______________________________________________
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.