cref2idx

0th

Percentile

Converting Excel cell references to indices

Converts Excel cell references to row & column indices

Keywords
utilities
Usage
cref2idx(x)
Arguments
x

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

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.

See Also

idx2cref, col2idx, idx2col, idx2aref, aref2idx, aref

Aliases
  • cref2idx
Examples
# NOT RUN {
cref2idx(c("$A$20", "B18"))
# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.