Converting Excel column names to indices

Converts Excel column names to indices.

col2idx(x)

Arguments

x

Character vector of Excel column names (e.g. "A", "AF", ...)

Value

Returns a vector of integers representing the corresponding column indices. Note that passing invalid column name references may result in an arbitrary number.

Author

Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch

See also

idx2col, cref2idx, idx2cref, idx2aref, aref2idx, aref

Examples

if (FALSE) { # \dontrun{
col2idx(c("A", "BTG"))
} # }