Is this something that cannot be handled using HSSFDataFormat? ~ amol
--- "Finnerty, Mary Ann (GE Healthcare)" <[EMAIL PROTECTED]> wrote: > 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/ > > --------------------------------------------------------------------- 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/
