Perhaps a silly question but are you certain there is no format applied to the cell? Have you tried passing the cell to the static formatCellValue() method of the DataFormatter class yet? If that works, it will only return a String for you but that should suffice for presentation purposes.
The second tool you could look at is the java.text.NumberFormat class. That may provide a way for you to convert from the 'scientific' notation; the only problem could be, as Josh indicated, that the value entered into the cell originally cannot be represented exactly. Yours Mark B Bipin.Jadhav2 wrote: > > > Hello, > > > > I have an excel file in which there is a column with no format > specified. The column contains numeric data > > > > e.g. 3333333333333333333333333333333333333 > > > > This numeric data gets converted in excel as 3.33333333333333E+36 > > > > How can I retrieve the original value using POI? > > Thanks and Regards > > Bipin Jadhav | Hinjewadi H1, Pune | > > www.cognizant.com <blocked::blocked::http://www.cognizant.com> | E: > [email protected] > <blocked::blocked::mailto:[email protected]> | VNet: 202166 | > M: +91-9922068837 > > > > > > This e-mail and any files transmitted with it are for the sole use of the > intended recipient(s) and may contain confidential and privileged > information. > If you are not the intended recipient, please contact the sender by reply > e-mail and destroy all copies of the original message. > Any unauthorised review, use, disclosure, dissemination, forwarding, > printing or copying of this email or any action taken in reliance on this > e-mail is strictly > prohibited and may be unlawful. > -- View this message in context: http://www.nabble.com/Excel-Exponential-problem-tp25592589p25607098.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
