Convert excel column name to integer index

Source: R/wrappers.R

Convert excel column name to integer index e.g. "J" to 10

convertFromExcelRef(col)

Arguments

col

An excel column reference

Examples

convertFromExcelRef("DOG")
#> [1] 3101
convertFromExcelRef("COW")
#> [1] 2441

## numbers will be removed
convertFromExcelRef("R22")
#> [1] 18