This is an old revision of this page, as edited by XCBRO172(talk | contribs) at 14:58, 10 October 2022(Fixed some spelling mistakes and unnecessary information of where to get statconn and rcom). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
Revision as of 14:58, 10 October 2022 by XCBRO172(talk | contribs)(Fixed some spelling mistakes and unnecessary information of where to get statconn and rcom)
RExcel is an add-in for Microsoft Excel. It allows access to 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
Using Excel as a GUI for R, making R functionality accessible through menus and dialog boxes instead of a command line oriented programming style. Using this paradigm, the widely used GUI package R Commander is available as an Excel menu bar.
RExcel works on Microsoft Windows (XP, Vista or 7), with Excel 2003, 2007,
2010, and 2013.[1]
It uses the statconnDCOM server and for certain configurations additionally the rcom package to access R from within Excel.[2]
RExcel's web site has a master installer RandFriendsSetup which installs R, many R packages, RExcel, and the infrastructure needed to run RExcel (rscproxy, rcom, the statconnDCOM server)
