Support an option to get formatCellValue in readExcel
koperagen opened this issue · 0 comments
koperagen commented
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