Constructing Excel area references — aref • XLConnect

Constructs an Excel area reference

aref(topLeft, dimension)

Arguments

topLeft: Top left corner. Either a character specifying a cell reference in the form "A1" or a numeric vector of length two specifying the corresponding coordinates.
dimension: Dimensions (numeric) of a 2-dimensional object (mostly a data.frame or a matrix)

Value

Returns the area reference (character) for the specified top left cell and dimension.

Author

Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch

See also

aref2idx, idx2aref, idx2cref, col2idx, idx2col

Examples

if (FALSE) { # \dontrun{
aref("A1", dim(mtcars))
aref(c(1, 1), dim(mtcars))
} # }