How do I get the stored cell formatting? Maffy -----Original Message----- From: Avik Sengupta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 23, 2006 10:54 AM To: [email protected] Subject: Re: Number Record
the 'default behaviour' is because Excel stores the data in that way.. ie, numbers are stored as IEEE floats within the excel file. On load, excel applies the stored cell formatting to the double before displaying on screen. If that is your requirement, that is what you should do. Regards - Avik Quoting "Finnerty, Mary Ann (GE Healthcare)" <[EMAIL PROTECTED]>: > I am using POI to read xls files - no interest in writing them - BUT I > need to get Number fields as plain text -- exactly as they are input > into the spreadsheet. > The default behavior is to read them in and turn them into doubles, > but I can't do that. > > Anyone know how I can get around this? > > Thanks! > Maffy > > > Mary Ann "Maffy" Finnerty > > GE Healthcare > > Integrated IT > > Enterprise Solutions > > Sr. Software Engineer > > > > T 206 607 5612 > > C 206 419 6784 > > E [EMAIL PROTECTED] > > www.gehealthcare.com > > > > 925 Fourth Avenue, Suite 400 > > Seattle, WA 98104 USA > > ----------- > I would rather be exposed to the inconveniences attending too much > liberty than to those attending too small a degree of it. > - Thomas Jefferson > <http://www.quotationspage.com/quotes/Thomas_Jefferson> > > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. --------------------------------------------------------------------- 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/
