Plus, don't forget the really useful utility, BuiltinFormats http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/BuiltinFormats.html
-----Original Message----- From: Nick Burch [mailto:apa...@gagravarr.org] Sent: Friday, April 25, 2014 3:10 AM To: POI Users List Subject: Re: Validating the excel date for MM/dd/yyyy format On Fri, 25 Apr 2014, Renjith R wrote: > I have to accept the first one and reject the second. > Since excel stores both these values in integer format, I am not able > to differentiate them. Simple - fetch the cell style that applies to the cell, get the formatting string that it uses, and see if that's one of the date formats you like Nick --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
