Description Usage Arguments Value Examples
Convert cell reference strings from A1 to R1C1 format. Strictly speaking,
this only makes sense for absolute references, such as
Because otherwise, we'd have to know the host cell of the reference. Set
strict = FALSE to relax and treat pure relative references, like
"B4"), as if they are absolute. Mixed references, like
"B$4"), will always return
NA, no matter the value of
A1_to_R1C1(x, strict = TRUE)
character vector of cell references in A1 format
logical, affects reading and writing of A1 formatted cell
character vector of absolute cell references in R1C1 format
1 2 3 4 5
A1_to_R1C1("$A$1") A1_to_R1C1("A1") ## raises a warning, returns NA A1_to_R1C1("A1", strict = FALSE) ## unless strict = FALSE A1_to_R1C1(c("A1", "B$4")) ## raises a warning, includes an NA, because A1_to_R1C1(c("A1", "B$4"), strict = FALSE) ## mixed ref always returns NA
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.