Hooking R from within Excel - DCOM? R add in for Excel?

Question

In the past I have used a DCOM connection to call R functions from Excel and from VBA inside of Excel. I just got a new laptop and have been looking for the install files for the R add in for Excel. I find references to it all over the place but they all point to R (D)COM Server project's home page at http://sunsite.univie.ac.at/rcom. That URL has been down now for some time. Is there another way to get the same functionality with another method? Is there a new project page?

I've never tried to use the DCOM server without the Excel Add-in. Is that a possibility?

Answer 1

Start by installing RExcelInstaller from CRAN via

> install.packages("RExcelInstaller")

and take it from there.

Answer 2

Hi,

I had exactly the same problem, found this answer, applied it and it worked. I think the server is just problematic at the moment.

I am trying this out for the first time, if you have a short example code for how to access R functionality that would be much appreciated? Thanks, GISbod.