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
https://issues.apache.org/bugzilla/show_bug.cgi?id=48140

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


Mime
View raw message