This is similar to what we're trying to do. When I read the spreadsheet, it has numbers like: 100, 10000, 0.967, etc. When I read them using POI, I get 100.0, 10000.0, 0.97, etc.
We're doing a medical application, and we need the numbers eXACTLY as entered into the spreadsheet to create our JUNIT tests for verification and validation before we get to the next stage in the delivery of our products. Right now, I am just saving the xls as text, and parsing the text into XML. I was hoping to get rid of a step by using POI, but I only seem to be able to get the double value and not the value that was entered into the spreadsheet (which represents the output produced by the module being tested). Maffy -----Original Message----- From: Alex Mayorga Adame [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 1:21 PM To: [email protected] Subject: Re: AW: Reading numeric values as strings from a cell Maybe I didn't stated my question correctly. But by doing that on a Cell formatted as Date you'd probably end up with something like: 38966 even if in your Worksheet you see: 6-Sep-06 I would like to store the latter, the data as seen in Excel on a String. Hope this clears up the confusion. Thanks in advance, Alex Daniel Noll wrote: > > Alex Mayorga Adame wrote: >> In short, there's a need to extract the contents of the cells as they >> show on the worksheet, extracted as a string no matter what the Cell >> number format is. >> >> Any help would be highly appreciated. > > We do this the trivial way, i.e. String.valueOf(doubleValue); > > Daniel > > > -- > Daniel Noll > ... > -- View this message in context: http://www.nabble.com/Reading-numeric-values-as-strings-from-a-cell-tf11 26130.html#a6179056 Sent from the POI - User forum at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
