keywordToTable: Extract a table from the excel template

In sstModel: Swiss Solvency Test (SST) Standard Models

Description

this function extracts tables from the excel input workbook.

Usage

keywordToTable(path, keyword, mapping.tables, keep = NULL, colNames = NULL)

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 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.

Value

the corresponding table.

See Also

excelToSstModel.

sstModel documentation built on May 2, 2019, 12:16 p.m.