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