write_latest_reported_hpop_summary: Write latest reported data to HPOP summary sheet
In ElliottMess/rapporteur: Reports on triple billion data

View source: R/write_dataframes_hpop_summary.R

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

write_latest_reported_hpop_summary(
  df,
  wb,
  sheet_name,
  ind_df,
  start_row,
  start_col,
  type_col,
  iso3,
  ind,
  year,
  value,
  transform_value,
  source_col,
  year_counts = c(2000, 2015),
  bounds,
  ind_ids
)

`df`	Data frame in long format filtered for a specific country, where 1 row corresponds to a specific year, and indicator.
`wb`	a `openxlsx` workbook to be edited.
`sheet_name`	character name of the sheet to update
`ind_df`	data frame containing the indicators in the correct order and format to be used.
`start_row`	integer start row of styling. Passed to `openxlsx::addStyle()`
`start_col`	integer start col of styling. Passed to `openxlsx::addStyle()`
`type_col`	Column name of column with type data.
`iso3`	Column name of column with country ISO3 codes.
`ind`	Column name of column with indicator names.
`year`	Column name of column with years.
`value`	Column name of column with indicator values.
`transform_value`	Column name of column(s) with transformed indicator values, used to calculate contributions.
`source_col`	Column name of column to store source information.
`year_counts`	integer vector with the year(s) to count the number of values available for a specific indicators. Defaults to 2000 and 2015.
`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
`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()`.