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!
It is very important that the installed version of R wrote its entry to the registry. If you have R installed without this registry entry, RExcel will not work. You need to reinstall R in that case. When reinstalling R all the packages will be retained, but any changes in the system wide profile (set in etc/Rprofile.site) will be lost.
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.
Download the statconn DCOM server and execute the program you downloaded
Start R as administrator (on Windows 7 and later you need to right-click the R icon and click the corresponding item)
In R, run the following commands (you must start R as administrator to do this):
options(install.packages.check.source = "no")
install.packages(c("rscproxy","rcom"),repos="http://www.autstat.com/download",
lib=.Library,type="win.binary")
library(rcom)
comRegisterRegistry()
Now you have rcom installed, but RExcel is not installed yet.
To install RExcel for 32bit Excel: download the RExcel installer and run this installation program. To install RExcel for 64bit Excell: 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.
Source
install.packages("RDCOMClient", repos = "http://www.omegahat.org/R", type = "source")
worked for me – Moe