Package-level declarations

Types

Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
class FormattingOptions(range: String, val formatter: DataFormatter = DataFormatter())
Link copied to clipboard
value class StringColumns(val range: String)
Link copied to clipboard

Functions

Link copied to clipboard
internal fun addMissingServiceDescriptorHint(exception: IOException, isClassAvailable: (String) -> Boolean): IOException
Link copied to clipboard
fun DataFrame.Companion.readExcel(sheet: Sheet, columns: String? = null, formattingOptions: FormattingOptions? = null, skipRows: Int = 0, rowsCount: Int? = null, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(file: File, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, stringColumns: StringColumns? = null, rowsCount: Int? = null, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(inputStream: InputStream, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, stringColumns: StringColumns? = null, rowsCount: Int? = null, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(url: URL, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, stringColumns: StringColumns? = null, rowsCount: Int? = null, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(path: Path, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, stringColumns: StringColumns? = null, rowsCount: Int? = null, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(fileOrUrl: String, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, stringColumns: StringColumns? = null, rowsCount: Int? = null, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(wb: Workbook, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, formattingOptions: FormattingOptions? = null, rowsCount: Int? = null, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame

Reads an Excel sheet to DataFrame.

fun DataFrame.Companion.readExcel(sheet: Sheet, columns: String? = null, formattingOptions: FormattingOptions? = null, skipRows: Int = 0, rowsCount: Int? = null, nameRepairStrategy: NameRepairStrategy = NameRepairStrategy.CHECK_UNIQUE, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(file: File, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, stringColumns: StringColumns? = null, rowsCount: Int? = null, nameRepairStrategy: NameRepairStrategy = NameRepairStrategy.CHECK_UNIQUE, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(inputStream: InputStream, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, stringColumns: StringColumns? = null, rowsCount: Int? = null, nameRepairStrategy: NameRepairStrategy = NameRepairStrategy.CHECK_UNIQUE, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(url: URL, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, stringColumns: StringColumns? = null, rowsCount: Int? = null, nameRepairStrategy: NameRepairStrategy = NameRepairStrategy.CHECK_UNIQUE, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(path: Path, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, stringColumns: StringColumns? = null, rowsCount: Int? = null, nameRepairStrategy: NameRepairStrategy = NameRepairStrategy.CHECK_UNIQUE, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(fileOrUrl: String, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, stringColumns: StringColumns? = null, rowsCount: Int? = null, nameRepairStrategy: NameRepairStrategy = NameRepairStrategy.CHECK_UNIQUE, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
fun DataFrame.Companion.readExcel(wb: Workbook, sheetName: String? = null, skipRows: Int = 0, columns: String? = null, formattingOptions: FormattingOptions? = null, rowsCount: Int? = null, nameRepairStrategy: NameRepairStrategy = NameRepairStrategy.CHECK_UNIQUE, firstRowIsHeader: Boolean = true, parseEmptyAsNull: Boolean = true): AnyFrame
Link copied to clipboard
fun StringColumns.toFormattingOptions(formatter: DataFormatter = DataFormatter()): FormattingOptions
Link copied to clipboard
fun <T> DataFrame<T>.writeExcel(wb: Workbook, columnsSelector: ColumnsSelector<T, *> = { all() }, sheetName: String? = null, writeHeader: Boolean = true): Sheet

Creates a new Sheet in the given Workbook and writes this DataFrame content into it.

fun <T> DataFrame<T>.writeExcel(outputStream: OutputStream, columnsSelector: ColumnsSelector<T, *> = { all() }, sheetName: String? = null, writeHeader: Boolean = true, factory: Workbook)

Writes this DataFrame to an Excel file using an existing Workbook instance into given OutputStream.

fun <T> DataFrame<T>.writeExcel(file: File, columnsSelector: ColumnsSelector<T, *> = { all() }, sheetName: String? = null, writeHeader: Boolean = true, workBookType: WorkBookType = WorkBookType.XLSX, keepFile: Boolean = false)
fun <T> DataFrame<T>.writeExcel(path: Path, columnsSelector: ColumnsSelector<T, *> = { all() }, sheetName: String? = null, writeHeader: Boolean = true, workBookType: WorkBookType = WorkBookType.XLSX, keepFile: Boolean = false)
fun <T> DataFrame<T>.writeExcel(path: String, columnsSelector: ColumnsSelector<T, *> = { all() }, sheetName: String? = null, writeHeader: Boolean = true, workBookType: WorkBookType = WorkBookType.XLSX, keepFile: Boolean = false)

Writes this DataFrame to an Excel file as a single sheet.