Error: Cannot get a NUMERIC value from a STRING cell

[jmrsnt]

There is an error when reading an xlsx file that has cells that have formulas that return string. The file formula_cell.xlsx was used as an example.

import org.jetbrains.kotlinx.dataframe.DataFrame
import org.jetbrains.kotlinx.dataframe.io.*
import org.jetbrains.kotlinx.dataframe.api.*

class MyApp {
    fun run() {
        val path = this.javaClass.getResource("formula_cell.xlsx")!!
        val df = DataFrame.readExcel(path)

        df.print()
    }
}

fun main(args: Array<String>) {
    MyApp().run()
}

This produces the error below:

Exception in thread "main" java.lang.IllegalStateException: Cannot get a NUMERIC value from a STRING cell
	at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:946)
	at org.apache.poi.xssf.usermodel.XSSFCell.getNumericCellValue(XSSFCell.java:260)
	at org.jetbrains.kotlinx.dataframe.io.XlsxKt.cellValue(xlsx.kt:293)
	at org.jetbrains.kotlinx.dataframe.io.XlsxKt.readExcel(xlsx.kt:242)
	at org.jetbrains.kotlinx.dataframe.io.XlsxKt.readExcel(xlsx.kt:182)
	at org.jetbrains.kotlinx.dataframe.io.XlsxKt.readExcel(xlsx.kt:101)
	at org.jetbrains.kotlinx.dataframe.io.XlsxKt.readExcel$default(xlsx.kt:91)
	at MyApp.run(Main.kt:8)
	at MainKt.main(Main.kt:15)

This occurs because when reading the cell value, if it is a formula, the value is being returned as stringCellValue, at xlsx.kt:293

dataframe/dataframe-excel/src/main/kotlin/org/jetbrains/kotlinx/dataframe/io/xlsx.kt

Lines 281 to 298 in c8ae4f2

	private fun Cell?.cellValue(sheetName: String): Any? =
	when (this?.cellType) {
	CellType._NONE -> error("Cell $address of sheet $sheetName has a CellType that should only be used internally. This is a bug, please report https://github.com/Kotlin/dataframe/issues")
	CellType.NUMERIC -> {
	val number = numericCellValue
	when {
	DateUtil.isCellDateFormatted(this) -> DateUtil.getLocalDateTime(number).toKotlinLocalDateTime()
	else -> number
	}
	}
	CellType.STRING -> stringCellValue
	CellType.FORMULA -> numericCellValue
	CellType.BLANK -> stringCellValue
	CellType.BOOLEAN -> booleanCellValue
	CellType.ERROR -> errorCellValue
	null -> null
	}

[Jolanrensen]

fix merged, thanks!