Download the latest version here

RAndFriends

This package will automatically install and configure

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:

You will get further instruction on how to install in RExcel. You can also install RExcel without the R package (RExcelInstaller), although this is not the recommended way.

You will have to install

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

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

Download statconnDCOM3.5-1B2_Noncommercial

Download STATCONN NONCOMMERCIAL USE LICENSE

statconnWS

This package contains statconnWS0.8-0B8Beta for Windows

You will have to install

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.

rcom

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 Uninstall any previous version of ROOo by removing the componentes ROOo.oxt, StatConnector.oxt, ROOoMacro.oxt, RInterface.oxt from the OpenOffice.org extension manager (Tools -> Extension manager, select the component and press Remove). Restart OpenOffice.org after removing the old extensions. To install the current version of ROOo, simply open the extension manager of OpenOffice.org (Tools -> Extension manager), press Add and select the file ROOo.oxt. When the installation has been completed sucessfully, verify the ROOo options (Options -> ROOo -> Path Settings). Depending on the operating system, several properties are available:
  1. 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.
  2. Windows: No options available. R-Home is determined by reading the Windows registry. Currently only the 32bit version of R is supported by ROOo.
  3. 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

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.