XLConnect (version 1.0.9)

col2idx: Converting Excel column names to indices

Description

Converts Excel column names to indices.

Usage

col2idx(x)

Value

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

Arguments

x

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

Author

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

See Also

idx2col, cref2idx, idx2cref, idx2aref, aref2idx, aref

Examples

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