aref

0th

Percentile

Constructing Excel area references

Constructs an Excel area reference

Keywords
utilities
Usage
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.

See Also

aref2idx, idx2aref, idx2cref, col2idx, idx2col

Aliases
  • aref
Examples
# NOT RUN {
aref("A1", dim(mtcars))
aref(c(1, 1), dim(mtcars))
# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.