You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Swati, Singhal (IE10)" <Sw...@honeywell.com> on 2003/11/17 10:21:28 UTC

Reading a Date

Hello,

How do i read a Date from an excel file??

Do i need to use DataFormat for that?? 
But how does my program know it's reading a Date from a particular cell??

Regards,
Swati


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


AW: Reading a Date

Posted by Karl-Heinz Zengerle <ka...@sawag.com>.
Hi Swati.

Dates come as numeric data. You've methods like getDateCellValue() (class
HSSFCell) and HSSFDateUtil.isCellDateFormatted() and
HSSFDateUtil.isValidExcelDate() to read it as a date or to check whether
it's date formatted.

Regards,

Karl-Heinz Zengerle.


-----Ursprüngliche Nachricht-----
Von: Swati, Singhal (IE10) [mailto:Swati.Singhal@honeywell.com]
Gesendet: Montag, 17. November 2003 10:21
An: poi-user@jakarta.apache.org
Betreff: Reading a Date


Hello,

How do i read a Date from an excel file??

Do i need to use DataFormat for that??
But how does my program know it's reading a Date from a particular cell??

Regards,
Swati


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org