Thanks. When I pasted the code snippet in the response I saw a BONEHEAD mistake. That fixed it. Thanks. Sorry to bother you all.
-----Original Message----- From: Amol Deshmukh [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 25, 2005 12:17 PM To: 'POI Users List' Subject: RE: Date cells Marc, Normally if the cell were not containing any data, I would expect it to be null or of type "blank". So could you post the relevant code snippet? Also, maybe you should run the code against another xls file that has an empty column with date format (I did that and the cell was returned as null) ~ amol > -----Original Message----- > From: Luce, Marc [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 25, 2005 10:06 AM > To: [email protected] > Subject: Date cells > > > I am trying to read an excel file and I am struggling with > Date fields. I have a column that has a custom date format > applied to the whole column and there is no data in it. When > I attempt to read this column (cell.getDateCellValue()) I > would expect it to return null. But it is returning today's > date. By the way, getCellType returns 'Numeric'. Is there > anyway for me to detect that that cell is empty? > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
