RExcel in R 3.0.x

Lisa Ann picture Lisa Ann · May 20, 2013 · Viewed 15.1k times · Source

RAndFriends, which includes all the items needed to run RExcel, includes just R 2.15.2.

I am currently using the latest version of R but rcom 2.3.1 and rscproxy 2.0.5, which I am currently using, do not allow me to start an R server within Excel.

Setting foreground R server whithin Excel returns a fatal error and R rejects any connection with Excel via rcom.

I get two error messages:

  1. R Server not available
  2. There seems to be no R process connected to Excel

The main difference with a running RExcel session is that in the latter you may see rscproxy and rcom to be loaded when you start a RExcel session.

Is there anyone who is currently using RExcel with R 3.0.1 who can explain me how he succeeded in running it (step by step)?

Answer

Lisa Ann picture Lisa Ann · May 22, 2013

Found it on statconn's Wiki section.

Assuming you have a suitable version of R installed, the following steps are necessary to install RExcel and the infrastructure. You need to be logged into Windows with administrator privileges to do this!

You also need to follow these instructions if you upgrade R, i.e. you install a new release of R after you have installed RExcel.

  1. Download the statconn DCOM server and execute the program you downloaded.
  2. Start R as administrator (on Windows 7 you need to right-click the R icon and click the corresponding item).
  3. In R, run the following commands (you must start R as administrator to do this).

Commands:

install.packages(c("rscproxy", "rcom"), repos = "http://rcom.univie.ac.at/download", lib = .Library)
library(rcom)
comRegisterRegistry()

Now you have rcom installed, but RExcel is not installed yet.

To install RExcel: download the RExcel installer and run this installation program. Installing RExcel this way will set the background server of R as the default R server for RExcel. You can change this in the configuration settings in R. If you want to set the foreground server as the default site wide server, there is an appropriate option in one of the dialogs of the installation.

The RExcel installer modifies one of the configuration files of R, the file Rprofile.site, usually found at a location like C:\Program Files\R\R-2.13.1\etc\Rprofile.site.

If you do not install RExcel and want the package rcom to be loaded into R each time you start it, you have to add the line

library(rcom)

to Rprofile.site. You have to start your editor as administrator to be able to modify this file.