extract_formulas: Extract formulas from an Excel workbook sheet
In hrbrmstr/xlsxtractr: Extract Things From Excel (xlsx) Files
Description
Usage
Arguments
Value
Examples
Description
Extract formulas from an Excel workbook sheet
Usage
1
extract_formulas(xlsx, n)
Arguments
xlsx
an xlsx object readin with read_xlsx()
n
sheet number
Value
a tibble with three columns (sheet, cell & formuma text). The
data frame may be empty if no formulas were found. The return will be NULL
if the sheet wasn't found and a warning to said effect will be issued.
Examples
1
2
3
4
5
6
7
8
doc <- read_xlsx(system.file("extdata/wb.xlsx", package="xlsxtractr"))
extract_formulas(doc, 1)
extract_formulas(doc, 2)
extract_formulas(doc, 3) # no formula
# gotta extract'em all!
map_df(seq_along(doc), ~extract_formulas(doc, .))
hrbrmstr/xlsxtractr documentation built on May 17, 2019, 5:54 p.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.
Description Usage Arguments Value Examples
Description
Extract formulas from an Excel workbook sheet
Usage
1 | extract_formulas(xlsx, n)
|
Arguments
xlsx |
an |
n |
sheet number |
Value
a tibble with three columns (sheet, cell & formuma text). The
data frame may be empty if no formulas were found. The return will be NULL
if the sheet wasn't found and a warning to said effect will be issued.
Examples
1 2 3 4 5 6 7 8 | doc <- read_xlsx(system.file("extdata/wb.xlsx", package="xlsxtractr"))
extract_formulas(doc, 1)
extract_formulas(doc, 2)
extract_formulas(doc, 3) # no formula
# gotta extract'em all!
map_df(seq_along(doc), ~extract_formulas(doc, .))
|
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.