Hello, 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.
Previous posts have alluded to using HSSFDateUtil.isADateFormat(int formatIndex, java.lang.String formatString)) as a possible solution. Is this correct? If yes, how does one obtain the value to the 'formatString' of a cell? Thank you. -- View this message in context: http://www.nabble.com/Date-cells-in-different-formats-treated-as-numeric-tp14629970p14629970.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]
