RExcel
Overview
Microsoft Excel
Microsoft Excel is a proprietary commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications...
. It allows access to the statistics package R
R (programming language)
R is a programming language and software environment for statistical computing and graphics. The R language is widely used among statisticians for developing statistical software, and R is widely used for statistical software development and data analysis....
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 GUIGuiGui or guee is a generic term to refer to grilled dishes in Korean cuisine. These most commonly have meat or fish as their primary ingredient, but may in some cases also comprise grilled vegetables or other vegetarian ingredients. The term derives from the verb, "gupda" in Korean, which literally...
for R, making R functionality accessible through menus and dialog boxes instead of a command line oriented programming style.
Unanswered Questions
Discussions