RExcel

This article has multiple issues. Please help or discuss these issues on the talk page. (Learn how and when to remove these template messages) This article contains content that is written like an advertisement. Please help by removing promotional content and inappropriate external links, and by adding encyclopedic content written from a neutral point of view. (September 2013) (Learn how and when to remove this template message) The topic of this article may not meet Wikipedia's notability guidelines for products and services. Please help to demonstrate the notability of the topic by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond a mere trivial mention. If notability cannot be shown, the article is likely to be merged, redirected, or deleted. Find sources:  –  ·  ·  · scholar · JSTOR (September 2013) (Learn how and when to remove this template message) (Learn how and when to remove this template message)

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.^[1] 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.^[2]

References[]

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[]

• RExcelInstaller at CRAN
• 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)