Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

keywordToValue

Extract a value from the excel template

Description

this function extracts single values from the excel input workbook.

Usage

keywordToValue(path, keyword, mapping.values)

Arguments

path

a character value. A valid path of an input excel workbook. The path can be relative or not.
keyword

a character value. A valid keyword corresponding to a cell.
mapping.values

a data.frame with three columns:

  • keyword: character, list of keywords.

  • name: character, sheet names corresponding to the keywords.

  • row: integer, row number corresponding to position in the excel sheet.

  • col: integer, column number corresponding to position in the excel sheet.

Value

the value of the corresponding cell.

See Also

sstModel

Swiss Solvency Test (SST) Standard Models

v1.0.0
GPL-3 + file LICENSE
Authors
Loris Michel [aut], Melvin Kianmanesh Rad [aut], Adrien Lamit [aut], Michael Schmutz [cre], Swiss Financial Market Supervisory Authority FINMA [cph]
Initial release

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.