|
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.〔http://www.statconn.com/products.html〕 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== * 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. 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「RExcel」の詳細全文を読む スポンサード リンク
|