poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <nick.bu...@alfresco.com>
Subject Re: How to read date/time/duration and other formats as a String from excel
Date Wed, 23 Nov 2011 11:53:41 GMT
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message