I think you are dealing with formatted cells. In which case these should help: http://jakarta.apache.org/poi/hssf/quick-guide.html#DataFormats http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFDataFormat.html
Regards, ~ amol > -----Original Message----- > From: animesh sonkar [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 19, 2005 6:47 AM > To: [email protected] > Subject: Reading Formula cell as String > > > > hi all, > > I am using POI v 2.5.1 . > > I want to read a Formula Cell which has a Numerical Value (say 05005). > > The problem is that i want to read this cell as a String such > that i get the Value "05005" and not as 5005 or 5005.0 > (reading the cell as Numerical value). > > I tries using HSSFCell.getStringValue() but it gives me a > blank string as said in the documentation. > > Please help me resolve this problem. > > Is there any such feature in POI v 3.0 ? > > --------------------------------------------------------------------- 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/
