reportRmd (version 0.1.0)

excelCol: Retrieve columns number from spreadsheet columns specified as unquoted letters

Description

Retrieve columns number from spreadsheet columns specified as unquoted letters

Usage

excelCol(...)

Value

a numeric vector corresponding to columns in a spreadsheet

Arguments

...

unquoted excel column headers (i.e. excelCol(A,CG,AA)) separated by commas

Examples

## Find the column numbers for excel columns AB, CE and BB
excelCol(AB,CE,bb)
## Get the columns between A and K and Z
excelCol(A-K,Z)