aref2idx: Converting Excel cell references to row and column based cell...

Description Usage Arguments Value Author(s) See Also Examples

Description

Converts Excel cell references to row and column based cell references

Usage

1

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 http://www.mirai-solutions.com

See Also

idx2aref, aref, cref2idx, idx2cref, col2idx, idx2col

Examples

1
aref2idx(c("A1:B6", "B6:C17"))


Search within the XLConnect package
Search all R packages, documentation and source code

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.