aref2idx: Converting Excel cell references to row and column based cell...
In XLConnect: Excel Connector for R
aref2idx R Documentation
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)
Arguments
x
Character vector of Excel cell references (e.g. "A1:B6", "B6:C17", ...)
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.
Author(s)
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
See Also
idx2aref, aref, cref2idx,
idx2cref, col2idx, idx2col
Examples
## Not run:
aref2idx(c("A1:B6", "B6:C17"))
## End(Not run)
XLConnect documentation built on Sept. 11, 2024, 8:04 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| aref2idx | R Documentation |
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)
Arguments
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.
Author(s)
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
See Also
idx2aref, aref, cref2idx,
idx2cref, col2idx, idx2col
Examples
## Not run:
aref2idx(c("A1:B6", "B6:C17"))
## End(Not run)
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.