Description Usage Arguments Value Examples
Convert various representations of a cell reference into an object of class
ra_ref
.
as.ra_ref
is NOT vectorized and therefore requires the input to
represent exactly one cell, i.e. be of length 1.
as.ra_ref_v
accepts input of length >= 1 and returns a list of
ra_ref
objects.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | as.ra_ref(x, ...)
as.ra_ref_v(x, ...)
## S3 method for class 'character'
as.ra_ref(x, fo = NULL, strict = TRUE, ...)
## S3 method for class 'character'
as.ra_ref_v(x, fo = NULL, strict = TRUE, ...)
## S3 method for class 'cell_addr'
as.ra_ref(x, ...)
## S3 method for class 'cell_addr'
as.ra_ref_v(x, ...)
|
x |
one or more cell references, as a character vector or
|
... |
further arguments passed to or from other methods |
fo |
either |
strict |
logical, affects reading and writing of A1 formatted cell
references. When |
a ra_ref
object, in the case of as.ra_ref
, or a
list of them, in the case of as.ra_ref_v
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | ## as.ra_ref.character()
as.ra_ref("$F$2")
as.ra_ref("R[-4]C3")
as.ra_ref("B4")
as.ra_ref("B4", strict = FALSE)
as.ra_ref("B$4")
## this is actually ambiguous! is format A1 or R1C1 format?
as.ra_ref("RC2")
## format could be specified in this case
as.ra_ref("RC2", fo = "R1C1")
as.ra_ref("RC2", fo = "A1", strict = FALSE)
## as.ra_ref_v.character()
cs <- c("$A$1", "Sheet1!$F$14", "Sheet2!B$4", "D9")
## Not run:
## won't work because as.ra_ref requires length one input
as.ra_ref(cs)
## End(Not run)
## use as.ra_ref_v instead
as.ra_ref_v(cs, strict = FALSE)
## as.ra_ref.cell_addr
ca <- cell_addr(2, 5)
as.ra_ref(ca)
## as.ra_ref_v.cell_addr()
ca <- cell_addr(1:3, 1)
## Not run:
## won't work because as.ra_ref methods not natively vectorized
as.ra_ref(ca)
## End(Not run)
## use as.ra_ref_v instead
as.ra_ref_v(ca)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.