kexcel-dsl/io.kexcel.driver/PoiDriver

PoiDriver

Implements ExcelDriver using Apache POI (SXSSF).

SXSSFWorkbook is a streaming extension of POI that writes data in chunks (defaulting to 100 rows) to keep memory usage low while still allowing random access to the recently written rows.

Constructors

PoiDriver

constructor()

Functions

applyOptions

open override fun applyOptions(options: WorkbookOptions)

Applies configuration options to the workbook.

finishRow

open override fun finishRow()

Finalize the current row.

finishSheet

open override fun finishSheet()

Finalize the current sheet.

finishWorkbook

open override fun finishWorkbook()

Finalize the workbook, write to the output stream, and release resources.

mergeCells

open override fun mergeCells(firstRow: Int, lastRow: Int, firstCol: Int, lastCol: Int)

Merge a range of cells into one.

nativeSheet

open override fun nativeSheet(): Any?

Returns the currently active native sheet object.

nativeWorkbook

open override fun nativeWorkbook(): Any?

Returns the underlying native workbook object.

setColumnWidth

open override fun setColumnWidth(col: Int, width: Int)

Set the width of a specific column.

startRow

open override fun startRow(rowNum: Int, height: Double? = null)

Start a new row at the specified rowNum.

startSheet

open override fun startSheet(name: String)

Create a new sheet with the given name.

startWorkbook

open override fun startWorkbook(outputStream: OutputStream)

Initialize the workbook and associate it with the provided outputStream.

writeCell

open override fun writeCell(col: Int, value: Any?, style: ExcelStyle? = null, link: String? = null)

Write a value to a specific cell in the current row.

writeFormula

open override fun writeFormula(col: Int, formula: String, style: ExcelStyle? = null)

Write a formula to a specific cell in the current row.