Excel

object Excel

Functions

Link copied to clipboard
fun columnIndex(column: String): Int
Link copied to clipboard
fun columnString(index: Int): String
Link copied to clipboard
fun createColumnRangeList(startCol: String, endCol: String): List<String>
Link copied to clipboard
fun findRow(sheet: ExcelSheet, column: String, matcher: (cellValue: String) -> Boolean): ExcelFoundRow
Link copied to clipboard
suspend fun readFile(file: File, sheetName: String, firstLine: Int, columns: List<String>): List<List<String>>
Link copied to clipboard
suspend fun readLine(file: String, sheetName: String, line: Int, trim: Boolean = true, columns: List<String>): List<String>
Link copied to clipboard
fun updateCell(sheet: ExcelSheet, rowIndex: Int, column: String, value: String)
Link copied to clipboard
suspend fun updateExcel(file: File, sheetName: String, update: (sheet: ExcelSheet) -> Boolean)
suspend fun updateExcel(file: String, sheetName: String, update: (sheet: ExcelSheet) -> Boolean)