If it has the date format set then sure. Glen Stampoultzis wrote:
>Yes but if it's displaying as a date in a sheet then the data format must be >set - right? > >----- Original Message ----- >From: "Andrew C. Oliver" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Friday, April 19, 2002 12:15 AM >Subject: Re: How to find out if a cell contains a Date > > >>No...if there is not dataformat set, then it will always be 0. >> >>Glen Stampoultzis wrote: >> >>>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 >>>> >>> >>> >> >> > > >
