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:
R Server not available
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)?
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
.
R
as administrator (on Windows 7 you need to right-click the R
icon and click the corresponding item).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.