idx2aref

0th

Percentile

Converting row and column based area references to Excel area references

Converts row & column based area references to Excel area references

Keywords
utilities
Usage
idx2aref(x)
Arguments
x

Numeric (integer) matrix or vector of indices. If a matrix is provided it should have four columns with the first two columns representing the top left corner (row and column indices) and the third & fourth column representing the bottom right corner. If a vector is provided it will be converted to a matrix by filling the vector into a 4-column matrix by row.

Value

Returns a character vector of corresponding Excel area references.

See Also

aref2idx, aref, idx2cref, cref2idx, idx2col, col2idx

Aliases
  • idx2aref
Examples
# NOT RUN {
idx2aref(c(1, 1, 5, 4))
# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.