sstModel: keywordToTransposedTable – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

keywordToTransposedTable

Extract a table from the excel template

this function extracts transposed tables from the excel input workbook.

keywordToTransposedTable(path, keyword, mapping.tables, colNames = NULL)

`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 table.
`mapping.tables`	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.
`colNames`	character vector, the colnames to be given to the parsed table.

the corresponding table.