keywordToTransposedTable: Extract a table from the excel template

Description Usage Arguments Value See Also

View source: R/excelToSstModel.R

Description

this function extracts transposed tables from the excel input workbook.

Usage

1
keywordToTransposedTable(path, keyword, mapping.tables, 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.

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.