cref2idx {XLConnect} | R Documentation |
Converts Excel cell references to row & column indices
cref2idx(x)
x |
Character vector of Excel cell references (e.g. "$A$20", "B18", ...) |
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.
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
idx2cref
, col2idx
, idx2col
,
idx2aref
, aref2idx
, aref
cref2idx(c("$A$20", "B18"))