We present some ways of using R in Excel and build an example application using the package rpart. Starting with simple interactive use of rpart in Excel, we eventually package the code into an Excel-based application, hiding all details (including R itself) from the end user. In the end, our application implements a service-oriented architecture (SOA) with a clean separation of presentation and computation layer.
Text and figures are licensed under Creative Commons Attribution CC BY 4.0. The figures that have been reused from other sources don't fall under this license and can be recognized by a note in their caption: "Figure from ...".
For attribution, please cite this work as
Baier, et al., "Creating and Deploying an Application with (R)Excel and R", The R Journal, 2011
BibTeX citation
@article{RJ-2011-011,
author = {Baier, Thomas and Neuwirth, Erich and Meo, Michele De},
title = {Creating and Deploying an Application with (R)Excel and R},
journal = {The R Journal},
year = {2011},
note = {https://doi.org/10.32614/RJ-2011-011},
doi = {10.32614/RJ-2011-011},
volume = {3},
issue = {2},
issn = {2073-4859},
pages = {5-11}
}