Women in Technology

Hear us Roar



Article:
  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.
Regards,
Unnati.