Execute R code directly in Microsoft Excel
Inference in Excel bridges the functionality of Excel and R, giving
you the best of both worlds. Inference in Excel enables you to create
dynamic Microsoft Excel spreadsheets that contain your data, R objects,
and R code. You can enter data directly into an Excel input worksheet
and then access that data directly from your R code. When executed,
Inference runs your R code and generates a Results Document that
contains the input data and numerical/graphical output all in a single
output document. With Inference in Excel, you can have it all: the power and
sophistication of R along with the familiarity and convenience of
Excel.
Inference in Excel allows you to do the following:
- create spreadsheet formulas that call the R scripting functions from
Excel
- read and write data from R to Excel ranges—that is, seamless
bi-directional data exchange between Excel and R
- enable strict data typing in Excel by assigning data types to Excel ranges
- create dynamic spreadsheets that include R scripting code that
interacts with and automates execution of data analyses and creation of graphics
- develop custom Excel import and export routines in dynamic scripting code
- display formatted text and graphical output from execution of dynamic
scripts in Excel
- publish custom Excel-based reports directly from your R-based analysis
- use Excel as a gateway to feed live data and your latest data model
parameters in a R scripting protocol
Inference in Excel Screenshots (click on the image for a full-size
screenshot):
Combine R code and spreadsheet inputs and outputs in familiar
Excel environment
Edit R code and R-Source files using the built-in Code Block Editor
Execute the your R code to create a Results Document in your
choice of formats
Create Data Sets that you can access from your R code