create_excel_from_template: Format data according to linked template

In MarcioFCMartins/MMartins: Custom Functions to Assist my Workflow

Format data according to linked template

Description

Format data according to linked template

Usage

create_excel_from_template(
  x,
  file,
  sheet_name = "data",
  template_file = NULL,
  template_sheet = NULL,
  all_columns = FALSE,
  allow_new_cols = FALSE
)

Arguments

x	Table to format (data frame or tibble)
file	Location where to save the formatted xlsx
sheet_name	Name of the sheet to save the data to
template_sheet	Name of the sheet in the template to use
all_columns	Should all columns from the template be included in the output file, even if not present in data? (empty columns will be filled in 'NA')
allow_new_cols	Should columns NOT present in the template be allowed?
template	Path for template to use

Value

Nothing, this function is used for its side effects - saving a file

MarcioFCMartins/MMartins documentation built on Nov. 8, 2024, 4:28 p.m.