B4J Question [Workaround][jPOI] Integers/decimal from cell

[KMatle]

I'm converting an Excel Sheet into a SQLite table. To create it, I need to know the column formats which I extract from the contents of the cells. Excel converts a decimal ending with .00 into an integer (except you format the cell to TEXT which isn't an option here).

Example:

Input is 28000,00. When you press enter, it is converted to 28000 (the 28000,00) comes from formatting the cells. The content is still 28000.

All other cells in that column contain "real" decimals (<> .00 at then end) which is ok. Only in that cell I get an INTEGER value instead a decimal (REAL).

Question: Is there an option to get the "display value" from a cell? (= the value the user sees in Excel including the formatting)?

 

[KMatle]

I solve it now by checking the first n rows and override INTEGER with decimal/REAL (in an internal variable). So even if the first one is seen as integer one following decimal will override it.

 

[stevel05]

Not sure if it's exactly what you are after, but the CellStyle Class has a method : getDataFormatString Which can be called using javaobect as it's not exposed.

Docs are here: http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/CellStyle.html