Thanks! -----Ursprüngliche Nachricht----- Von: Nick Burch [mailto:[email protected]] Gesendet: Wednesday, November 23, 2011 12:54 PM An: POI Users List Betreff: Re: How to read date/time/duration and other formats as a String from excel
On Wed, 23 Nov 2011, ARD Marx Tobias wrote: > I was trying to read values from an Excel sheet with the following > formats: > > cell format is: m/d/yy > cell format is: [$-F400]h:mm:ss\ AM/PM > cell format is: [h]:mm:ss I think the class you want is DataFormatter: http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.html That provides methods to format cells to strings based on their contents and formatting rules Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
