keywordToTable: Extract a table from the excel template

Description Usage Arguments Value See Also

View source: R/excelToSstModel.R

Description

this function extracts tables from the excel input workbook.

Usage

1
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 4, 2018, 1:04 a.m.