create_excel_archive: Create Excel Archive

In retodomax/FunRZ: Useful functions

Create Excel Archive

Description

Create Excel Archive

Usage

create_excel_archive(
  l,
  filename = "data_archive",
  convention_table_path = NULL,
  column_headers_path = NULL,
  ERD = TRUE,
  pk = NULL,
  connectors = NULL,
  erd_height = 800
)

Arguments

l	list containing tibbles
filename	path and filename (without suffix) of the file to create
convention_table_path	path to file containing conventions (e.g. C:/Users/858782/DSM/BovaerAnimalTrials - General/01_Admin/Animal_Trial_Column_Names_RZ.xlsx)
column_headers_path	path to file created by create_rename_table
ERD	Boolean, should Entity-Relationship-Diagram be drawn and added as tab?
pk	list defining the primary keys per table as character string
connectors	character vector defining the connections between tables
erd_height	height of the ERD plot in pixels (manually adjust if necessary)

retodomax/FunRZ documentation built on July 30, 2023, 6:42 p.m.