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