Jakarta POI Excel Numeric/Timstamp Conversion problem and Warning
Posted on 2006-05-10
I am using POI and have 2 problems:
1. In my Excel spreadsheet there is a cell that contains timestamp data. It appears as "5/30/2005 3:58:20 PM". When I run my app to get the value I am told the data type is NUMERIC, the value that gets retrieved is 38502.66550925926 . Does anyone know how to convert this to a java.util.Date object?
2. "[WARNING] Unknown Ptg 2a (42) at cell (994,25)" - There doesn't seem to be a problem with the cell. Does anyone know why I am getting this warning?