is_range: Test that Excel formulas are ranges
In nacnudus/tidyxl: Read Untidy Excel Files
is_range R Documentation
Test that Excel formulas are ranges
Description
is_range() tests whether or not an Excel formula is a range.
A formula like A1 is a range, whereas a formula like MAX(A1,2) is not.
Formulas are not evaluated, so it returns FALSE for formulas that would
eventually resolve to arrange (e.g. INDEX(A1:A10,2)) but that are not
immediately a range.
Usage
is_range(x)
Arguments
x
character vector of formulas
Examples
x <- c("A1", "Sheet1!A1", "[0]Sheet1!A1", "A1,A2", "A:A 3:3", "MAX(A1,2)")
is_range(x)
nacnudus/tidyxl documentation built on Jan. 17, 2024, 9:26 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| is_range | R Documentation |
Test that Excel formulas are ranges
Description
is_range() tests whether or not an Excel formula is a range.
A formula like A1 is a range, whereas a formula like MAX(A1,2) is not.
Formulas are not evaluated, so it returns FALSE for formulas that would
eventually resolve to arrange (e.g. INDEX(A1:A10,2)) but that are not
immediately a range.
Usage
is_range(x)
Arguments
x |
character vector of formulas |
Examples
x <- c("A1", "Sheet1!A1", "[0]Sheet1!A1", "A1,A2", "A:A 3:3", "MAX(A1,2)")
is_range(x)
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.