sstModel: keywordToTable – R documentation

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

keywordToTable

Extract a table from the excel template

this function extracts tables from the excel input workbook.

keywordToTable(path, keyword, mapping.tables, keep = NULL, 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. `endCol`: integer, ending column number corresponding to position in the excel sheet.
`keep`	integer vector, which columns should be kept or removed from `startCol:endCol`.
`colNames`	character vector, the colnames to be given to the parsed table.

the corresponding table.