RExcel

Infobox_Software
name = RExcel



caption =
developer = Erich Neuwirth
latest_release_version = 3.0-1
latest_release_date = July 29, 2008
platform = R programming language, Microsoft Excel, Microsoft Windows
genre = Statistical software, Spreadsheet
license = GNU Lesser General Public License
website = [http://rcom.univie.ac.at]

RExcel is an addin for Microsoft Excel. It allows to access the statistics package
R from within Excel.

The main features are
* Data transfer (matrices and data frames) between R and Excel in both directions
* Running R code directly from Excel ranges
* Writing macros calling R to perform calculations without exposing R to the user
* Calling R functions directly from cell formulas, using Excel's autoupdate mechanism to trigger recalculation by R
* Installed using the package RExcelInstaller from CRAN

RExcel only works on Microsoft Windows (XP or Vista) and with Excel 2000, 2002, 2003 and 2007.It uses either the R(D)COM server or the rcom package to access R from within Excel.

References

Baier T. and Neuwirth. E. Excel :: COM :: R.Computational Statistics 22 (2007)

Neuwirth, E. [http://www.statistik.uni-dortmund.de/useR-2008/abstracts/Neuwirth.pdf R meets the Workplace] - Embedding R into Excel and making it more accessible. Paper presented at the UseR 2008, Dortmund

Narasimhan, B. Paper presented at the Interface 2007, Philadelphia

Baier, T., Heiberger, R., Neuwirth, E., Schinagl, K., & Grossmann, W. Paper presented at the UseR 2006, Vienna.

Konnert, A. [http://www.r-project.org/useR-2006/Abstracts/Konnert.pdf| LabNetAnalysis - An instrument for the analysis of data from laboratory networks based on RExcel] Paper presented at the UseR 2006, Vienna.

External links

* [http://rcom.univie.ac.at Official Home Page]
* [http://cran.r-project.org/web/packages/RExcelInstaller/index.html RExcelInstaller at CRAN]