Write times series sheet

export_hpop_country_summary_xls Export a country-specific for HPOP billion.

Usage

write_hpop_timeseries_sheet(
  df,
  wb,
  sheet_name,
  start_row,
  start_col,
  value_col,
  ind_df,
  end_year
)

Arguments

df

data frame to be written

wb

a openxlsx workbook to be edited.

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()

value_col

Column name of column with indicator values.

ind_df

data frame containing information on indicators

end_year

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

Value

openxslx Workbook object. Output file is in output_folder.