XLConnect (version 1.0.7)

aref: Constructing Excel area references

Description

Constructs an Excel area reference

Usage

aref(topLeft, dimension)

Value

Returns the area reference (character) for the specified top left cell and 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)

Author

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

See Also

aref2idx, idx2aref, idx2cref, col2idx, idx2col

Examples

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