formatTotals: Extends formatDataFrame to correctly format rows that are...

Description Usage Arguments Details

Description

This function loads an Excel workbook that contains data and then formats rows labeled with "Total" to conform to the DSAR guidelines.

Usage

1
formatTotals(wb, df, styleLookup, sheet = 2, sr = 7)

Arguments

wb

Optional workbook object as returned by formatDataFrame or loadWorkbook

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

Details

Possible values for the styleList are "textStyle", "moneyStyle", "percStyle", "countStyle", "yearStyle". They should be self-explanatory and they conform with the DSAR template requirements.


sachsmc/rreporttools documentation built on May 29, 2019, 12:55 p.m.