rowAndCell.kt

fun Sheet.row(rowNumber: Int? = null, block: Row.() -> Unit): Row {
    return createRow(rowNumber ?: physicalNumberOfRows).apply(block)
}

fun Row.cell(value: Any? = null, column: Int? = null, block: Cell.() -> Unit = {}): Cell {
    val cell = createCell(column ?: physicalNumberOfCells)
    when (value) {
        is Calendar -> cell.setCellValue(value)
        is Date -> cell.setCellValue(value)
        is Boolean -> cell.setCellValue(value)
        is Double -> cell.setCellValue(value)
        is String -> cell.setCellValue(value)
        is RichTextString -> cell.setCellValue(value)
    }
    return cell.apply(block)
}