Description Usage Arguments Details
This function loads an Excel workbook that contains data and then formats rows labeled with "Total" to conform to the DSAR guidelines.
1 | formatTotals(wb, df, styleLookup, sheet = 2, sr = 7)
|
wb |
Optional workbook object as returned by
|
df |
Data frame to write out |
styleLookup |
Character vector of format types, see details |
sheet |
Number of sheet to write output to |
sr |
Start row of output |
Possible values for the styleList
are
"textStyle"
, "moneyStyle"
,
"percStyle"
, "countStyle"
,
"yearStyle"
. They should be self-explanatory and
they conform with the DSAR template requirements.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.