Okay, I just tested this and it's not returning 0. It's working as expected. Can you show us some code were this isn't working?
Regards Glen ----- Original Message ----- From: "Oliver Fuerniss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 12:33 AM Subject: Re: How to find out if a cell contains a Date > 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] >
