| Developer(s) | Erich Neuwirth |
|---|---|
| Stable release | 3.2.9
/ 6 January 2013 |
| Platform | R programming language, Microsoft Excel, Microsoft Windows |
| Type | Statistical software, Spreadsheet |
| License | RExcel Noncommercial license or RExcel Commercial license |
| Website | www.statconn.com |
RExcel is an add-on for Microsoft Excel. It allows access to the statistics package R from within Excel using the statconnDCOM server and, for certain configurations, the rcom package.
RExcel runs on Microsoft Windows (XP, Vista , or 7), with Excel 2003, 2007, 2010, and 2013.[1]
The RExcelInstaller package was removed from CRAN due to FOSS license restrictions.[2]
Functionality
The primary feature set includes:
- Data transfer (of matrices and data frames) between R and Excel in both directions.
- The execution of R code from Excel ranges.
- Implementation of macros which call R to perform calculations.
- Calling R functions from cell formulas, using Excel's auto-update mechanism to trigger recalculation by R.
- Using Excel as a GUI for R.
References
- ↑ "statconn". www.statconn.com. Archived from the original on 2014-10-28. Retrieved 2014-10-24.
- ↑ "CRAN". Retrieved 2023-11-10.
Bibliography
- Baier T., Neuwirth E., De Meo M: Creating and Deploying an Application with (R)Excel and R R Journal 3/2, December 2011.
- Baier T. and Neuwirth. E. Excel :: COM :: R. Computational Statistics 22 (2007).
- Heiberger R. and Neuwirth E.: R Through Excel, Springer Verlag 2009.
- Neuwirth, E.: R meets the Workplace - Embedding R into Excel and making it more accessible. Paper presented at the UseR 2008, Dortmund.
- Narasimhan, B.: Disseminating Statistical Methodology and Results via R and Excel: Two Examples. Paper presented at the Interface 2007, Philadelphia.
- Baier, T., Heiberger, R., Neuwirth, E., Schinagl, K., & Grossmann, W.: Using R for teaching statistics to nonmajors: Comparing experiences of two different approaches. Paper presented at the UseR 2006, Vienna.
- Konnert, A.: LabNetAnalysis - An instrument for the analysis of data from laboratory networks based on RExcel Paper presented at the UseR 2006, Vienna.
External links
| Features |  | |
|---|---|---|
| Implementations |
| |
| Packages | ||
| Interfaces | ||
| People | ||
| Organisations | ||
| Publications | ||
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.