XLConnect (version 1.1.0)

cref2idx: Converting Excel cell references to indices

Description

Converts Excel cell references to row & column indices

Usage

cref2idx(x)

Value

Returns a numeric matrix with two columns and as many rows as cell references that have been provided. The first column represents the row indices and the second column represents the column indices.

Arguments

x

Character vector of Excel cell references (e.g. "$A$20", "B18", ...)

Author

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

See Also

idx2cref, col2idx, idx2col, idx2aref, aref2idx, aref

Examples

if (FALSE) {
cref2idx(c("$A$20", "B18"))
}