Learn R Programming

excelstrippr (version 0.1.2)

strip_metadata: Strip Report MetaData From Excel File

Description

Strip Report MetaData From Excel File

Usage

strip_metadata(from, promote = NA, ...)

Arguments

from

the file path to the excel report.

promote

logical. Should first non-NA row be promoted to column names? Default tries to make a reasonable determination.

...

extra parameters to pass to the read_excel function

Value

a data frame containing the tabular data from the report

Examples

Run this code
# NOT RUN {
strip_metadata("./man/example/example-report")
# specify a particular sheet
strip_metadata("my-excel-file.xlsx", sheet = "report summary")
# }

Run the code above in your browser using DataLab