The first thing to try would be using the DataFormatter class - http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.html. It has a method - formatCellValue(Cell) - that will return to you a String encapsulating the data formatted just as the user would have seen it on the worksheet.
No promise that tis will solve the problem for you and, if it does not, pease post again onto the list. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/handling-special-formatting-in-POI-tp4270835p4270866.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]
