clean_workbook_list: Export a clean workbook

In gnoblet/impactR: Ease IMPACT's data and database officers woRk

Export a clean workbook

Description

The clean_workbook functions exports a list or a dataframe/tibble to nice xlsx file using openxlsx.

• clean_workbook_list() takes a named_list as main arg and writes a xlsx file where each list item is a tab.

• clean_workbook_df() takes a dataframe as main arg and writes a single-tabbed xlsx file.

Usage

clean_workbook_list(
  named_list,
  path,
  col_width = 15,
  max_width = 60,
  font_name = "Leelawadee",
  font_size = 10,
  table_style = "TablestyleMedium10"
)

clean_workbook_df(
  df,
  name,
  path,
  col_width = 15,
  max_width = 60,
  font_name = "Leelawadee",
  font_size = 10,
  table_style = "TablestyleMedium10"
)

Arguments

named_list	A named list of tibbles/dataframes.
path	A full full or relative path that includes file name.
col_width	Minimum column width. Default to 15.
max_width	Maximum column width. Default to 60.
font_name	Font name. Default to "Leelawadee".
font_size	Font size. Default to 10.
table_style	Excel table style. Default to "TablestyleMedium10".
df	Dataframe to export
name	Character string if the spreadsheet name

Value

A written xlsx file

Functions

• clean_workbook_list(): Export a clean workbook from a named list of dataframes

• clean_workbook_df(): Export a clean workbook from a single dataframe

gnoblet/impactR documentation built on March 20, 2023, 2:24 a.m.