Sheet

class Sheet(source)

Properties

Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
val rows: List<List<Data?>>
Link copied to clipboard
Link copied to clipboard

Functions

Link copied to clipboard
Link copied to clipboard
fun cell(cellIndex: CellIndex): Data
Link copied to clipboard
fun clearRow(rowIndex: Int): Boolean
Link copied to clipboard
fun findAndReplace(source: <Error class: unknown class>, target: String, first: Int = -1, startingRow: Int = -1, endingRow: Int = -1, startingColumn: Int = -1, endingColumn: Int = -1): Int
Link copied to clipboard
fun getColumnAutoFit(columnIndex: Int): Boolean
Link copied to clipboard
fun getColumnWidth(columnIndex: Int): Double
Link copied to clipboard
fun getRowHeight(rowIndex: Int): Double
Link copied to clipboard
fun insertColumn(columnIndex: Int)
Link copied to clipboard
fun insertRow(rowIndex: Int)
Link copied to clipboard
fun insertRowIterables(row: List<CellValue?>, rowIndex: Int, startingColumn: Int = 0, overwriteMergedCells: Boolean = true)
Link copied to clipboard
fun merge(start: CellIndex, end: CellIndex, customValue: CellValue? = null)
Link copied to clipboard
fun removeColumn(columnIndex: Int)
Link copied to clipboard
fun removeRow(rowIndex: Int)
Link copied to clipboard
fun row(rowIndex: Int): List<Data?>
Link copied to clipboard
fun selectRange(start: CellIndex, end: CellIndex? = null): List<List<Data?>?>
Link copied to clipboard
fun selectRangeValues(start: CellIndex, end: CellIndex? = null): List<List<Any?>>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
fun setColumnAutoFit(columnIndex: Int)
Link copied to clipboard
fun setColumnWidth(columnIndex: Int, columnWidth: Double)
Link copied to clipboard
fun setDefaultColumnWidth(columnWidth: Double = EXCEL_DEFAULT_COLUMN_WIDTH)
Link copied to clipboard
fun setDefaultRowHeight(rowHeight: Double = EXCEL_DEFAULT_ROW_HEIGHT)
Link copied to clipboard
fun setMergedCellStyle(start: CellIndex, mergedCellStyle: CellStyle)
Link copied to clipboard
fun setRowHeight(rowIndex: Int, rowHeight: Double)
Link copied to clipboard
fun unMerge(unmergeCells: String)
Link copied to clipboard
fun updateCell(cellIndex: CellIndex, value: CellValue?, cellStyle: CellStyle? = null)