evaluate_formula: Evaluate all formulae in an existing Excel file
In departmentfortransport/odsconvertr: Package of VBS helper functions to facilitate simple Excel processes in R
View source: R/evaluate_formulas.R
evaluate_formula R Documentation
Evaluate all formulae in an existing Excel file
Description
Uses VBA code to open an Excel file and to recalculate any formula in it.
This ensures that all Excel formulae have been executed in a file which may have been updated without being opened (e.g. using code)
Usage
evaluate_formula(path)
Arguments
path
path to Excel file; can be either a relative or absolute file path
departmentfortransport/odsconvertr documentation built on Dec. 5, 2023, 11:56 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.
View source: R/evaluate_formulas.R
| evaluate_formula | R Documentation |
Evaluate all formulae in an existing Excel file
Description
Uses VBA code to open an Excel file and to recalculate any formula in it. This ensures that all Excel formulae have been executed in a file which may have been updated without being opened (e.g. using code)
Usage
evaluate_formula(path)
Arguments
path |
path to Excel file; can be either a relative or absolute file path |
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.