ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  Reading and Writing Excel Files with POI
Subject:   Reading Data From Excel using HSSFWorkbook +Java
Date:   2008-04-20 21:16:57
From:   Unnati
Response to: Reading Data From Excel using HSSFWorkbook +Java

Hi, I tried the above code to read date and time value using POI but This column is displayed in numeric value and not in time format. i.e. 0.3069444444444444 is displayed for time 7:22:00 AM. Can u please tell me what the conversion method is for this? Also Plz tell what can be done for below Eg. 14321926 in excel gets displayed as 1.4321926E7 .
Please help...

Thanks in advance.