Thanks for your response, Nick. An earlier question/response(http://www.nabble.com/HSSFCell-Time-Code-String-Treated-as-Date-Numeric-to14224700.html#a14224700 - Nick Burch Dec 10, 2007; 01:54pm ) refers to "grab the format string for the the cell". How can I get the format string of a cell? Since the HSSFWorkbook.getWorkbook() is a protected method, is there a different way to obtain this format string?
Thanks again. Nick Burch wrote: > > On Fri, 4 Jan 2008, MPras wrote: >> I have an excel spreadsheet with dates in formats like 'M/D/yyyy' and >> 'Sunday, January 09, 2005'. Dates in format 'M/D/yyyy' are interpreted >> correctly as Date (HSSFDateUtil.isCellDateFormatted() returns true). >> The same method is unable to identify other date formats as Date and >> they end up appearing as double. > > Try with poi 3.0.2 beta 1, it has improved date detection > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Date-cells-in-different-formats-treated-as-numeric-tp14629970p14668754.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]
