Further to Nick's response, can you please let us have more information. What do you want to do with the values once you have them? If all you want to do is print them onto the screen or onto a report then the easiest technique is simply to use the DataFormatter class, or one of it's subclasses, to convert the cell's contents into a String. DataFormatter actually uses the formatting object applied to the cell by the sheets original creator to ensure that the resulting String looks just as the cell did. However, if you need to recover numeric or date/time values for performing calculations then you need to test the cells type and call the correct method to recover it's contents.
Yours Mark B Bugzilla from [email protected] wrote: > > https://issues.apache.org/bugzilla/show_bug.cgi?id=48140 > > Nick Burch <[email protected]> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > Status|REOPENED |RESOLVED > Resolution| |INVALID > > --- Comment #4 from Nick Burch <[email protected]> 2009-11-24 08:38:05 UTC > --- > Please do not ask basic usage questions by re-opening old bugs relating to > something else! > > Check the list archives, yours is a common misconception about excel, and > all > the answers you seek have come up on the list many times. > > -- > 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: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/DO-NOT-REPLY--Bug-48140--New%3A-Cannot-get-a-numeric-value-from-a-text-cell-tp26218150p26499898.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
