kexcel-dsl/io.kexcel.driver/FastExcelDriver

FastExcelDriver

Implements ExcelDriver using org.dhatim.fastexcel.

FastExcel offers superior performance and lower memory usage compared to Apache POI, making it an excellent choice for high-performance Excel generation tasks.

Constructors

FastExcelDriver

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.