To read back the cell value with the formatting rules applied take a look at the DataFormatter class http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.html and specifically the formatCellValue() methods.
On Wed, Aug 7, 2013 at 7:16 AM, mkumar <[email protected]> wrote: > Folks, > > I am new to apache POI and facing few issues. > > 1) In one the excel column I have value as $5000. Apache poi is converting > it to number and giving it back. > > Reason is I have different currency in Excel so I donot want poi to give > just numberf > > I am using cell.getNumericValue method. > > 2) Same thing is with %. If it is 131% it returns 1.31 as number. Any one > knows how to retrieve this AS IS from excel. > > > > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Apache-poi-reading-numeric-value-tp5713506.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] > >
