Re: [R] Excel calling R functions

From: Horace Tso <Horace.Tso_at_pgn.com>
Date: Fri, 01 Jun 2007 09:29:24 -0700

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.

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 - 16:40:19 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 - 17:31:26 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.