Neha Patil (Editor)

RExcel

Updated on
Edit
Like
Comment
Share on FacebookTweet on TwitterShare on LinkedInShare on Reddit
Developer(s)
  
Erich Neuwirth

Website
  
rcom.univie.ac.at

Stable release
  
3.2.9 / 6 January 2013; 4 years ago (2013-01-06)

Platform
  
R programming language, Microsoft Excel, Microsoft Windows

Type
  
Statistical software, Spreadsheet

License
  
RExcel Noncommercial license or RExcel Commercial license

RExcel is an addin 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.
  • Installed using the package RExcelInstaller from CRAN

    • RExcel works on Microsoft Windows (XP, Vista or 7), with Excel 2003, 2007, 2010, and 2013. It uses the statconnDCOM (available from the same site as RExcel) server and for certain configurations additionally the rcom package (available from CRAN) to access R from within Excel.

    References

    RExcel Wikipedia
    (Text) CC BY-SA


    Similar Topics