Kotlin/dataframe

Support an option to get formatCellValue in readExcel

koperagen opened this issue · 0 comments

You might want to get cell value not how it is represented in the xlsx file and seen by Apache Poi, but as a String
There's method that does exactly this
We can provide an argument to specify what columns should be read by value methods like stringCellValue, numericCellValue, etc. and by formatCellValue

val style: CellStyle = getCellStyle()
val dataFormatter = DataFormatter()
val formattedCellValue = dataFormatter.formatCellValue(this, style)
return formattedCellValue