keywordToValue: Extract a value from the excel template

Description Usage Arguments Value See Also

View source: R/excelToSstModel.R

Description

this function extracts single values from the excel input workbook.

Usage

1
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

excelToSstModel.


sstModel documentation built on May 4, 2018, 1:04 a.m.