Jakarta POI Excel Numeric/Timstamp Conversion problem and Warning

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?

Who is Participating?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.