[Experimental]

read_excel_template() is generally called through another function, such as read_techdatareport() or read_maintrepair(). Returns a list of tibbles from an Excel template structure. Each tibble corresponds to one Excel sheet.

This function is currently experimental because it facilitates reading from the Excel templates, which may not be stable.

read_excel_template(
  file,
  table_spec,
  file_type,
  .show_check = FALSE,
  .coerce_spec = TRUE
)

Arguments

file

Path to the Excel template file to read.

table_spec

List containing data specifications for both tables, and fields within the tables

file_type

Type of Excel template used. Used only for status messages.

.show_check

Logical whether to print information about the file check to the console or not.

.coerce_spec

Logical whether to coerce all column data types to those from the data models. If FALSE, the types will be as detected upon read by the parser.

Value

A list of tibbles for the file. Result will be of class maintrepair or techdatareport.