this function extracts single values from the excel input workbook.
keywordToValue(path, keyword, mapping.values)
a character value. A valid path of an input excel workbook. The path can be relative or not.
a character value. A valid keyword corresponding to a cell.
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.
the value of the corresponding cell.