cell

fun cell(col: Int? = null, value: Any? = null, formula: String? = null, style: ExcelStyle? = null, link: String? = null)

Defines a cell in the current row.

If [col] is not provided, the index increments automatically.

Parameters

col

the zero-based column index

value

the data content (String, Number, Boolean, or Date types)

formula

the optional Excel formula (e.g., "SUM(A1:B1)")

style

the optional style to apply to this cell

link

the optional hyperlink URL

Throws

if both value and formula are provided