poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From eugenebalt <eugeneb...@yahoo.com>
Subject Getting Decimal Instead of Text String
Date Fri, 03 Jun 2011 21:47:57 GMT
I am using Apache POI-HSSF for working with Excel files.

I have a cell in my spreadsheet that looks like "115". I verified that it is
formatted as "Text" (Format Cells -> Text).

However, when I read it in as
row.getCell(0).toString()

I get this string: "115.0"

This is incorrect. I should be getting "115" since it's explicitly formatted
as Text. How can I get the desired result? The cell can be anything, numbers
or characters, and I expect the same string as in the cell. Thanks


--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Getting-Decimal-Instead-of-Text-String-tp4452662p4452662.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message