Skip to content

Support an option to get formatCellValue in readExcel #669

@koperagen

Description

@koperagen

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

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions