xlsxtractor: This function loads a xlsx file and extracts the passed list...

Description Usage Arguments Value

View source: R/xlsxtracter.R

Description

This function loads a xlsx file and extracts the passed list to a dataframe

Usage

1
2
3
4
5
6
7
xlsxtractor(
  infile,
  colrow,
  header = NULL,
  sheet = "Sheet1",
  one_to_many = list(c(NULL))
)

Arguments

infile

Path to the input xlsx file

colrow

List of columns, rows

header

Optional header vector. NULL is used to indicate using the first row as a header

sheet

Optional sheet name

one_to_many

replicates the reference to the data frame length Syntax is list(c(colname), c(column letter), c(row letter))

Value

A data frame


ebenp/xlsxtracter documentation built on Dec. 20, 2021, 3:12 a.m.