Jakarta POI Excel Numeric/Timstamp Conversion problem and Warning

Posted on 2006-05-10
Last Modified: 2008-01-09
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?

Question by:anthony0007
    1 Comment
    LVL 92

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    Title # Comments Views Activity
    seriesUp challenge 7 80
    IT Company 5 53
    Spring Controller - inheritance in request parameter 3 29
    wordappend challenge 8 45
    After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
    Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
    This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now