aref2idx: Converting Excel cell references to row and column based cell references
Description
Converts Excel cell references to row and column based cell references
Usage
aref2idx(x)
Value
Returns a numeric matrix with four columns and as many rows as cell references that have
been provided. The first two columns represent the coordinates of the top left corner (row, column)
and the third and fourth columns represent the bottom right corner of the referenced area.
Arguments
x
Character vector of Excel cell references (e.g. "A1:B6", "B6:C17", ...)