Skip to contents

Write indicator list for HPOP summary sheet

Source: R/write_dataframes_hpop_summary.R
write_indicators_hpop_summary.Rd

write_hpop_summary_sheet() writes all the content and styling for the HPOP summary sheet. Used within export_hpop_country_summary_xls()

Usage

write_indicators_hpop_summary(ind_df, wb, sheet_name, bounds)

Arguments

ind_df

data frame containing the indicators in the correct order and format to be used.

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

Value

openxslx Workbook object. Output file is in output_folder.