statconnDCOM, rcom and RExcel
This Wiki gives up to date information about the statconn projects which allow to use R embedded in Windows applications. Examples of the projects are
- statconnDCOM server
- statconnWS SOAP/http web service
- rcom R package
The Wiki is part of the Web site http://rcom.univie.ac.at It is world readable, but to be able to contribute you have to register and login. When you are registered, you may edit and change existing pages, but you still cannot create new links. Furthermore, when editing, please do not change the names of existing links.
If you think that a new pages should be created to organize thing better, send a short email to the maintainer, erich.neuwirth at univie.ac.at Table of contents
The managers of CRAN have decided that our tools do not comply with their license policy. As a consequence the our R packages RExcelInstaller and rcom are not available any more from CRAN. Furthermore, RAndFriends was downloading these packages from CRAN and therefore does not work any more.
The How to install page in this wiki has instructions to install our tools under these new circumstances.
We will provide a working solution for installing the Home and Student version in the near future.
statconn.NET will be the newest member of the statconn family. Documentation is already available for preview from the “Download” page. Example code is provided in the wiki.
The relationships and internal structures of the components have undergone a major revision. Some components used previously (StatConnectorSRV, R_Scilab_DCOM) are not available any more and also are not supported any more. By the same reason, the installer RAndFriendsLight also is not available any more.
What are all these packages?
statconnDCOM Server is a server which allows to seamlessly integrate R or Scilab into other applications. It is required by rcom and by RExcel.
rcom is an R package allowing to have R and another program running at the same time and let them communicate.
rscproxy is an R package which is required for rcom and for the statconn (D)COM Server.
sciproxy is the counterpart to rproxy required for integration of Scilab into other applications.
RExcel is an Excel addin using statconnCOM or rcom to allow Excel to call R from within Excel.
The addin works in Excel 2007, 2010, 2013 and 2016.
There are separate versions of the addin for 32bit and 64bit versions of Excel.
RExcel needs statconnDCOM and possibly rcom. statconnDCOM implements the background server (R is only accessible through Excel, not in a separate RGui or RTerm Window)
rcom implements the foreground server, meaning that Excel connects with R, but R can be accessed simultaneously from RGui or Rterm also.
statconnDCOM implements StatConnectorSrv, which is a (D)COM server
which allows any COM client (e.g. all MS Office programs)
to access R and Scilab. In MS Office programs this is done using R.
RExcel is an example of how VBA can be used in Excel
to access R.
Information about the underpinnings of COM technology (including examples) is available on MSDN