use_run_matrix: Multiple Spreadsheets
In CivilEngineerUK/interactexcel: Interact with Excel Calculations
Description
Make changes to a spreadsheet and extract the outputs from
specified cells using a run matrix as an input.
Usage
1
2
use_run_matrix(run_matrix = NULL, file_location = NULL,
sheet = "Sheet1", folder = "results", round_dp = 3)
Arguments
run_matrix
a file path to the input matrix OR the matrix itself
file_location
the full path of the calculation spreadsheet
sheet
the sheet in the spreadsheet in which you wish to change values
folder
the folder to save the results to
round_dp
the number of significant figures to round to. Defaults to 3
CivilEngineerUK/interactexcel documentation built on May 27, 2019, 2:05 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description
Make changes to a spreadsheet and extract the outputs from specified cells using a run matrix as an input.
Usage
1 2 | use_run_matrix(run_matrix = NULL, file_location = NULL,
sheet = "Sheet1", folder = "results", round_dp = 3)
|
Arguments
run_matrix |
a file path to the input matrix OR the matrix itself |
file_location |
the full path of the calculation spreadsheet |
sheet |
the sheet in the spreadsheet in which you wish to change values |
folder |
the folder to save the results to |
round_dp |
the number of significant figures to round to. Defaults to 3 |
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.