this function extracts transposed tables from the excel input workbook.
keywordToTransposedTable(path, keyword, mapping.tables, colNames = NULL)
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 table.
a data.frame with following fields:
keyword
: character, list of keywords.
name
: character, sheet names corresponding to the keywords.
startRow
: integer, starting row number corresponding to position in
the excel sheet.
startCol
: integer, starting column number corresponding to position in
the excel sheet.
character vector, the colnames to be given to the parsed table.
the corresponding table.