Hi Nick, Thank you for your reply. Yes I tried to read. But they have example for writing the cell, but not for reading the custom formated cell.
As I am new to POI, I am not sure how to get the cell data with the custom formatted time(00:01:05.00 - hh:mm:ss.00) If you know how to get the data, please help. Thanks, Maria Nick Burch wrote: > > On Fri, 11 Apr 2008, mariag wrote: >> I am new to this HSSF. I have an urgent requirement to read an excel >> file. >> But it has a time field that I don't know how to read it. >> >> Can anyone please help me in reading a date cell with excel custom >> format hh\:mm\:ss.00? if I have the value in the cell as 00.00.18.13 >> ,excel is displaying itas 12:00:18 AM. > > I'm not sure quite what you're after, but have you tried reading: > http://poi.apache.org/hssf/quick-guide.html#CreateDateCells > http://poi.apache.org/hssf/quick-guide.html#DataFormats > ? > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/read-custom-format-date-hh%3Amm%3Ass%3A00%E2%80%8F-tp16628223p16677662.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
