KSLCore/ksl.utilities.io/ExcelUtil/readToMap

readToMap

fun readToMap(sheetName: String, pathToWorkbook: Path = KSL.excelDir.resolve("${sheetName}.xlsx"), skipFirstRow: Boolean = false): Map<String, Double>

This is the reverse operation to the function writeToExcel() for a Map The strings "+Infinity", "-Infinity", and "NaN" in the value column are correctly converted to the appropriate double representation. Any rows that have empty cells (null) are skipped in the processing.

Parameters

sheetName

the name of the sheet holding the map. If the workbook does not contain the named sheet then an empty map is returned

pathToWorkbook

the path to the workbook file. By default, this is assumed to be a workbook in the KSL.excelDir directory with the name "sheetName.xlsx"

skipFirstRow

if true the first row of the sheet is skipped because it contains a header. The default is false.