| XLRCODE | Run R code in a local environment and transfer values from and to Excel. Function memory is cleared after calculation. |
| XLRCODE_ENV | Run R code in a pre-specified environment and transfer values from and to Excel |
| XLRSCRIPT | Run R script in a local environment and transfer values from and to Excel. Function memory is cleared after calculation. |
| XLRSCRIPT_ENV | Run R script in a pre-specified environment and transfer values from and to Excel |
| XLRFUNC | Call an R function in a local environment and transfer values from and to Excel |
| XLRFUNC_ENV | Call an R function in a pre-specified environment and transfer values from and to Excel |
Run R code in a local environment and transfer values from and to Excel. Function memory is cleared after calculation.
| Return | Function returns the visible result of the last command of the code. In case it is not visible, function returns TRUE. |
| Parameters | Description |
| Commands | R code |
| [ParamsList]... | Sequence of optional paired parameters, where the first parameter is a valid variable name (as a text string) and the second parameter is its value. Variable names with the (optional) following suffixes are coerced to specific data types: (n) => double, (s) => string, (d) => date, (df) => data frame. Other coercions are available at the "Data types" worksheet. |
Run R code in a pre-specified environment and transfer values from and to Excel.
| Return | Function returns the visible result of the last command of the code. In case it is not visible, function returns TRUE. |
| Parameters | Description |
| [Environment] | Name of the environment in which to run the R code. If omitted or empty, code is run inside Global environment. |
| Commands | R code |
| [ParamsList]... | Sequence of optional paired parameters, where the first parameter is a valid variable name (as a text string) and the second parameter is its value. Variable names with the (optional) following suffixes are coerced to specific data types: (n) => double, (s) => string, (d) => date, (df) => data frame. Other coercions are available at the "Data types" worksheet. |
Run R script in a local environment and transfer values from and to Excel. Function memory is cleared after calculation.
| Return | Function returns the visible result of the last command of the script. In case it is not visible, function returns TRUE. |
| Parameters | Description |
| ScriptPath | R script file path |
| [ParamsList]... | Sequence of optional paired parameters, where the first parameter is a valid variable name (as a text string) and the second parameter is its value. Variable names with the (optional) following suffixes are coerced to specific data types: (n) => double, (s) => string, (d) => date, (df) => data frame. Other coercions are available at the "Data types" worksheet. |
Run R script in a pre-specified environment and transfer values from and to Excel.
| Return | Function returns the visible result of the last command of the script. In case it is not visible, function returns TRUE. |
| Parameters | Description |
| [Environment] | Name of the environment in which to run the R code. If omitted or empty, code is run inside Global environment. |
| ScriptPath | R script file path |
| [ParamsList]... | Sequence of optional paired parameters, where the first parameter is a valid variable name (as a text string) and the second parameter is its value. Variable names with the (optional) following suffixes are coerced to specific data types: (n) => double, (s) => string, (d) => date, (df) => data frame. Other coercions are available at the "Data types" worksheet. |
Call an R function in a local environment and transfer values from and to Excel. Function memory is cleared after calculation.
| Return | Function returns the result of the R function called. |
| Parameters | Description |
| FunctionName | Name of the function to be called. Consider specifying the whole function path to avoid confusion. |
| [AfterFunction] | In case the function called returns a complex structure and one wants to access a nested element, this parameter value is appended to the result object, i.e. [1] |
| [ParamsList]... | Sequence of optional paired parameters, where the first parameter is a valid variable name (as a text string) and the second parameter is its value. In case one wants to list arguments in the default order received by the function, without identifying them, provide "..." as a parameter followed by the desired arguments. Mixing identified and non-identified arguments is possible as long as all non-identified parameters come at the end. Moreover, one can pass a string with the literal specification of parameter names and their respective arguments as in R code. For that, one should pass "*" as the =XLRFUNC parameter name and the literal R expression as its value. Variable names with the (optional) following suffixes are coerced to specific data types: (n) => double, (s) => string, (d) => date, (df) => data frame. Other coercions are available at the "Data types" worksheet. |
Call an R function in a pre-specified environment and transfer values from and to Excel.
| Return | Function returns the result of the R function called. |
| Parameters | Description |
| [Environment] | Name of the environment in which to call the R function. If omitted or empty, function is called inside Global environment. |
| FunctionName | Name of the function to be called. Consider specifying the whole function path to avoid confusion. |
| [AfterFunction] | In case the function called returns a complex structure and one wants to access a nested element, this parameter value is appended to the result object, i.e. [1] |
| [ParamsList]... | Sequence of optional paired parameters, where the first parameter is a valid variable name (as a text string) and the second parameter is its value. In case one wants to list arguments in the default order received by the function, without identifying them, provide "..." as a parameter followed by the desired arguments. Mixing identified and non-identified arguments is possible as long as all non-identified parameters come at the end. Moreover, one can pass a string with the literal specification of parameter names and their respective arguments as in R code. For that, one should pass "*" as the XLRFUNC parameter name and the literal R expression as its value. Variable names with the (optional) following suffixes are coerced to specific data types: (n) => double, (s) => string, (d) => date, (df) => data frame. Other coercions are available at the "Data types" worksheet. |
- Convert Excel dates to R dates or vice-versa.