as i know the ExcelRead version 1.6.x from Andy Kahn has a function to find out if the cell is a date. But how it is done if you say that these fields are always numerical and getDataFormat() always returns 0???
Am Donnerstag, 18. April 2002 16:09 schrieben Sie: > Dates are actually stored by Excel as numeric. getDataFormat() sounds like > a bug. We will investigate. > > Regards, > > Glen Stampoultzis (TriNexus Pty Ltd) > +63 3 9753-6850 0402 835 458 > ICQ: 62722370 EMail: [EMAIL PROTECTED] > > ----- Original Message ----- > From: "Oliver Fuerniss" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, April 18, 2002 11:25 PM > Subject: How to find out if a cell contains a Date > > > Hello, > > i am using the poi dev version 1.5.0 and i have the following questions: > > Is there an way to find out, if the current cell contains a date? The > > method > > > getCellType() delivers always CELL_TYPE_NUMERIC for my dates. Why is > > there > > no > > > constant for cell.getCellType() like HSSFCell.CELL_TYPE_DATETIME? > > Also cell.getCellStyle().getDataFormat() is always 0 (General). > > Thanx > > Oliver -- __________________________________________________ inubit - Your e-Business Partner! inubit AG Oliver F�rni�, Dipl.-Inform.(FH) L�tzowstra�e 105-106 D-10785 Berlin Fon: +49 (0) 30 - 72 61 12 - 0 Fax: +49 (0) 30 - 72 61 12 - 100 Freecall 0800-Go inubit Web: http://www.inubit.com mailto:[EMAIL PROTECTED]
