<div>
<div class="content wysiwyg-content">
I am using POI and have 2 problems:<br />
<br />
1. In my Excel spreadsheet there is a cell that contains timestamp data. It appears as &quot;5/30/2005 &nbsp;3:58:20 PM&quot;. 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?<br />
<br />
<br />
2. &quot;[WARNING] Unknown Ptg 2a (42) at cell (994,25)&quot; - There doesn't seem to be a problem with the cell. Does anyone know why I am getting this warning?<br />
<br />

</div>
</div>


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?



Jakarta POI Excel Numeric/Timstamp Conversion problem and Warning

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.