columnFormula

fun columnFormula(header: String, style: ExcelStyle? = null, headerStyle: ExcelStyle? = null, cellStyle: (T) -> ExcelStyle?? = null, formula: (Int, T) -> String)

Defines a formula column in the data sheet.

Parameters

header

the column header text

style

optional static style for data cells in this column

headerStyle

optional style override for this column's header cell only

cellStyle

optional dynamic style evaluated per item

formula

a lambda to generate the Excel formula string for each item (index, item) -> String