poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 48140] Cannot get a numeric value from a text cell
Date Thu, 05 Nov 2009 19:01:55 GMT

Nick Burch <nick@torchbox.com> changed:

           What    |Removed                     |Added
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID

--- Comment #2 from Nick Burch <nick@torchbox.com> 2009-11-05 11:01:53 UTC ---
You need to check the type of the cell. If it's of type numeric, then call
getNumericCellValue(). If it's of type string, call getRichStringCellValue().
The type tells you which one you can call.

Sometimes, excel decides to store a number in a cell of type string. For those
cases, fetch the string value and parse it to a number in java. See the
documentation on the site and/or javadocs for more details

Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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

View raw message