Styles scenarios sheet

style_header_hpop_summary_sheet styles the title and sub-title of the worksheet header.

Usage

style_scenarios_sheet(
  df,
  wb,
  billion = c("hep", "hpop", "uhc"),
  sheet_name,
  start_row,
  start_col,
  scenario_col = "scenario",
  scenarios_order,
  df_wide,
  ind_df,
  ind_ids,
  this_iso3
)

Arguments

df

data frame to be written

wb

a openxlsx workbook to be edited.

billion

Billion to be used for billion styling when relevant: either "hep", "hpop", or "uhc" when no billion to be applied.

sheet_name

character name of the sheet to update

start_row

integer start row of styling. Passed to openxlsx::addStyle()

start_col

integer start col of styling. Passed to openxlsx::addStyle()

scenario_col

Column name of column with scenario identifiers. Useful for calculating contributions on data in long format rather than wide format.

scenarios_order

(character) vector in which scenario_col should be dplyr::arrange

df_wide

wide version of df generated by write_uhc_timeseries_sheet

ind_df

data frame containing information on indicators

ind_ids

Named vector of indicator codes for input indicators to the Billion. Although separate indicator codes can be used than the standard, they must be supplied as a named vector where the names correspond to the output of billion_ind_codes().

this_iso3

character iditenfying the country being styled.

Value

openxslx Workbook object. Output file is in output_folder.