Write and style summary box in UHC summary sheet

write_summary_box_uhc_summary writes and styles the summary box in UHC summary worksheet. Used in write_uhc_summary_sheet().

Usage

write_summary_box_uhc_summary(
  wb,
  sheet_name,
  iso,
  start_year,
  end_year,
  boxes_bounds
)

Arguments

wb

a openxlsx workbook to be edited.

sheet_name

character name of the sheet to update

iso

ISO3 code of country to summarize.

start_year

Base year for contribution calculation, defaults to 2018.

end_year

End year(s) for contribution calculation, defaults to 2019 to 2025.

boxes_bounds

named list of bounds for data frame boxes to be written in sheet.

Value

openxslx Workbook object. Output file is in output_folder.