Create NASIS XLSX Import Files

Usage

create_import_template(
  .data,
  file,
  template_name,
  columns,
  sheet,
  template_version = "1.0",
  delimeter = "<delimiter|||>"
)

create_import_template_from_mapping(
  .data = NULL,
  coltype = c("logical", "physical"),
  file,
  template_name,
  sheet,
  ...
)

Arguments

.data: Optional: data.frame containing NASIS column physical or logical names to be used to populate the template. Default is an empty template.
file: output file name
template_name: template name
columns: columns in template
sheet: XLSX sheet name
template_version: template version; default: "1.0"
delimeter: used internally for creating matrix representation for writing to file. Default: "<delimiter|||>"
coltype: Either "physical" for physical column names, or "logical" (default) for logical column names (default for worksheet import maps).
...: Additional arguments passed to create_import_template()

Value

writes XLSX or CSV file

Details

Column names containing "_" are converted to " "