Download the latest version here
- RAndFriends
- RExcel
- SWord
- statconn.NET
- statconnDCOM
- statconnWS
- statconn R Packages
- ROOo
- Scilab within Excel
- Creating and Deploying an Application with (R)Excel and R
RAndFriends
This package will automatically install and configure- R 2.15.2
- rscproxy 2.0-5
- rcom 2.2-5
The R version contained in RAndFriends contains the 32bit and the 64bit version of R. On 32bit versions of Windows, only the 32bit version of R will be installed, on 64bit versions of Windows, both the 32bit and the 64bit versions of R will be installed. All the statconn tools (statconnDCOM, rcom, RExcel ..) work only with the 32bit version of R, and RExcel works only with 32bit versions of Excel. RExcel is actively tested and supported for Excel 2003, Excel 2007, and Excel 2010.
RAndFriendsSetup will also download and install a suitable version of the statconnDCOM server and of RExcel during installation. Therefore you will need a working Internet connection during the installation process.
The installer named RAndFriends will (among other things) download the
most recent release of
the free noncommercial version of RExcel and the most
recent release of the noncommercial version of statconnDCOM.
The number after the V in RAndFriendsInstaller indicates the version
of RExcel available at the release of RAndFriends.
If a new version of RExcel was released after the release of
RAndFriends,
downloaded version of RExcel will have a
version number higher than this number.
This version of RAndFriends was created 20130117.
Download RAndFriendsSetup2152V3.2-9-1
If you installed RAndFriendsSetup2120V3.1-9-1, you might have problems uninstalling R 2.12.0 contained in this setup. If that is the case, follow these instructions to uninstall this version of R.
We also give you information how to download all sources for R and the R packages included in RAndFriends.
RExcel
The current version is RExcel 3.2.9. It works only with 32bit versions of Excel (which can be installed on 64bit versions of Windows). The Excel versions supported are 2003, 2007, and 2010.
RExcel 3.2.9 requires R 2.12.0 (or later). The foreground server might work with earlier versions of R, but we do not officially support this.
The easiest way to install RExcel is to use the package 'RExcelInstaller' from CRAN. To install RExcel this way, you have to start R as admininstrator. On Windows XP, you should be logged in as administrator, on Windows Vista and Windows 7 right-click on the R icon and select 'Run as administrator'.In R, run the following commands:
- install.packages("RExcelInstaller")
- library(RExcelInstaller)
You will have to install
- a suitable version of R
- a matching version of rscproxy
- statconnDCOM or rcom with statconnDCOM
Download RExcel 3.2.9
Download REXCEL NONCOMMERCIAL USE LICENSE
SWord Noncommercial Use
This package contains SWord 1.0-1B1
You will have to install
- a suitable version of R
- a matching version of rscproxy
- statconnDCOM or rcom with statconnDCOM
Download SWord 1.0-1B1 Noncommercial
Download SWORD NONCOMMERCIAL USE LICENSE
statconn.NET
statconn.NET is not yet available. We provide an early version of the documentation for download as a ZIPped CHM file
statconnDCOM Noncommercial Use
This package contains the noncommercial use version of statconnDCOM3.5-1B2.
You will have to install
- a suitable version of R (>= 2.12.0)
- a matching version of rscproxy (>= 2.0-1)
Download statconnDCOM3.5-1B2_Noncommercial
Download STATCONN NONCOMMERCIAL USE LICENSE
statconnWS
This package contains statconnWS0.8-0B8Beta for Windows
You will have to install
- a suitable version of R (>= R 2.12.0)
- a matching version of rscproxy
This beta/test version expires 13-04-01. It will stop working then
Download statconnWS 0.8-0B8Beta
You will need a password for installation. Please ask Thomas for it. You will get access for evaluation purposes.
statconn R Packages
This section lists some statconn R packages. These are provided as binary packages only
scExcel
scExcel is used to access Microsoft Excel from R. This package requires rcom, rscproxy and statconnDCOM.
Currently, scExcel can be used on 32-Bit R for Windows only.
- Download scExcel for R 2.15.1
- Download STATCONN NONCOMMERCIAL USE LICENSE
rcom
- Download rcom for R 2.15.x
- Download STATCONN NONCOMMERCIAL USE LICENSE
ROOo
ROOo is an OpenOffice.org extension. The current version (0.751) works on Mac OSX (10.5 or higher), Windows (XP, Vista or Windows 7), and Linux x86 (32bit as well as 64bit). To run ROOo you need- a suitable version of R (>= 2.12)
- a matching version of rscproxy
- OpenOffice.org 3.0 or higher (ROOo has been testes with LibreOffice and NeoOffice too)
- Mac OSX: Verify the directories configured for R-Home and Proxy. Modify these settings if required. You may also choose between the 32bit and the 64bit version of R.
- Windows: No options available. R-Home is determined by reading the Windows registry. Currently only the 32bit version of R is supported by ROOo.
- Linux: Verify the directories configured for R-Home and Proxy. Modify these settings if required. 64bit Linux requires 64bit versions of OpenOffice.org and R, hence the 64bit option cannot be changed for the Linux version of ROOo.
This package contains ROOo 20090112-1 Beta.
You will have to install
- a suitable version of R
- a matching version of rscproxy
Download ROOo.oxt
Scilab within Excel
An Excel workbook demonstrating how to use Scilab directly from within Excel.
Requires statconnDCOM. The statconnDCOM documentation explains how
to install the components needed to access Scilab through statconnDCOM.
Download ScilabTest.xls
Creating and Deploying an Application with (R)Excel and R
This is the example code for the article Creating and Deploying an
Application with (R)Excel and R: Recursive Partitioning and Regression
Trees.
Requires statconnDCOM and RExcel. For a new installation, you should consider
downloading RAndFriends.
- Download RExcelRpartDemo.zip (demo worksheets)
- Download RExcelrpart_1.0.tar.gz (R source package)
- Download RExcelrpart_1.0.zip (R binary package for R 2.10.0, Windows)