Thanks a lot Karl, One more problem initialy it was able to read as date no problem , then I tried experimenting with it & finaly again to date format , it started showign number now , no matter what date format I change.
Thanks Regards Birendar S Waldiya -----Original Message----- From: KHZ (SAW) [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 5:04 PM To: 'POI Users List' Subject: AW: Dates Converted To Number Hi Birendar. 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. In case of formula you just have a cell type formula. In that case you either know the type of its content or you've to guess its type and take the most reasonable value (the one different from being empty). Guessing the wrong type doesn't result in an exception. It returns an empty value of the result type then. Long ago I also was astonished at the first moment. Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: Birendar Waldiya [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 12. Mai 2006 12:50 An: [email protected] Betreff: Dates Converted To Number Hi , Can any one tell me why the dates are getting converted as numbers when I am trying to read dates from a xls file . When does it happen that date are converted to number ?? This is realy an issue that may hampher business Please guide Thanks Regards Birendar S Waldiya --------------------------------------------------------------------- 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/
