Skip to contents

Style HPOP summary sheet latest reported in main data frame

Source: R/style_hpop_summary_sheet.R
style_hpop_latest.Rd

Used within write_latest_reported_hpop_summary()

Usage

style_hpop_latest(wb, sheet_name, bounds, data_type)

Arguments

wb

a openxlsx workbook to be edited.

sheet_name

character name of the sheet to update

bounds

named integer vector identifying integer sheet start and end reference column. All parameters must be numerical. For converting Excel column references to integer references see openxlsx::int2col(). Must have the following named elements:

  • start_col: start column

  • end_col: end column

  • start_row: start row

  • end_row: end row

data_type

character vector of class(es) of the data to be styled. Can be one of "numeric", "integer", "Date", "character", or "chr_type"

Value

openxslx Workbook object. Output file is in output_folder.