[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 672
  • Last Modified:

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?

1 Solution

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now