Converting number representing a date in Excel to a Java Date object

Question

I have a date column in Excel, but when I'm reading it in my Java application I'm getting the value as number.

Example

Excel Date

1/1/2013

I'm getting it as

41275.00

How to convert the number to a date in my Java application?

Answer 1

Here is a minimal working example how to convert an Excel date to a Java date:

        Date javaDate= DateUtil.getJavaDate((double) 41275.00);
        System.out.println(new SimpleDateFormat("MM/dd/yyyy").format(javaDate));

which returns

01/01/2013

You also need to import the following packages:

java.text.SimpleDateFormat
java.util.Date