An experiment in turning an Excel file into an R program. It takes as inputs an excel file (in xlsx format) a set of cell references as inputs and a set of cell references as outputs and returns a function that can be used to “execute” the excel workbook from R. Currently only very basic excel operations are supported.
For example, this excel workbook implements a tree model with inputs on the first sheet and outputs on the second.
The inputs are on the first tab, making up a column with a few gaps, and with labels in the column to its left:
The outputs are all over the second sheet and have labels two rows below
Then create a function that can generate these outputs
## <an xlerate object>
## TST pos neg LTBI LTBI free LTBI ## 71.90691 500.00000 67.58273 1342.00000 0.00000 1342.00000 ## LTBI free ## 0.00000
MIT © Imperial College of Science, Technology and Medicine
Please note that this project is released with a Contributor Code of Conduct. By participating in this project you agree to abide by its terms.