Learn R Programming

openxlsx (version 4.1.0)

convertFromExcelRef: Convert excel column name to integer index

Description

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

Usage

convertFromExcelRef(col)

Arguments

col

An excel column reference

Examples

Run this code
# NOT RUN {
convertFromExcelRef("DOG")
convertFromExcelRef("COW")

## numbers will be removed
convertFromExcelRef("R22")
# }

Run the code above in your browser using DataLab