Skip to content

Instantly share code, notes, and snippets.

@ejjunju
Last active December 8, 2015 07:38
Show Gist options
  • Save ejjunju/9122929 to your computer and use it in GitHub Desktop.
Save ejjunju/9122929 to your computer and use it in GitHub Desktop.
This file contains a script for installing the RExcel plugin in Excel so that you can control R from Excel
install.packages(c("rscproxy","rcom"),repos="http://rcom.univie.ac.at/download",lib=.Library)
installstatconnDCOM()
library(rcom)
comRegisterRegistry()
download.file(url="http://rcom.univie.ac.at/download/RExcel.distro/RExcelInst.latest.exe",mode="wb",destfile="Rexcel.exe")
system("Rexcel.exe")
install.packages(c("Rcmdr","RcmdrPlugin.HH"),lib=.Library,dep=TRUE)
library(Rcmdr)
@ejjunju
Copy link
Author

ejjunju commented Feb 20, 2014

@tapiwak
Copy link

tapiwak commented Dec 8, 2015

Hello. When I run

library(Rcmdr)
I get the following error:

Loading required package: RcmdrMisc
Loading required package: sandwich
Error in get(Info[i, 1], envir = env) :
cannot open file 'C:/Users/Lesley/Documents/R/win-library/3.2/Formula/R/Formula.rdb': No such file or directory
Error: package ‘RcmdrMisc’ could not be loaded

How do I fix this. Please help.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment