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

by

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

More Related Contents:

  1. How to read and write excel file
  2. How can I read numeric strings in Excel cells as string (not numbers)?
  3. CSV file with “ID” as first item is corrupt in Excel
  4. How to read Excel cell having Date with Apache POI?
  5. JSP generating Excel spreadsheet (XLS) to download
  6. Read XLSX file in Java [closed]
  7. Embed files into Excel using Apache POI
  8. Apache POI – FileInputStream works, File object fails (NullPointerException)
  9. Apache poi Excel line chart points
  10. How to set axis’ labels in a Line Chart using Apache Poi
  11. How should I escape commas and speech marks in CSV files so they work in Excel?
  12. Removing a row from an Excel sheet with Apache POI HSSF
  13. Apache POI autoSizeColumn Resizes Incorrectly
  14. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  15. Merging cells in Excel using Apache POI
  16. Password Protected Excel File
  17. Create Bar Chart in Excel with Apache POI
  18. Excel Cell Style issue
  19. How to insert a row between two rows in an existing excel with HSSF (Apache POI)
  20. Exception when writing to the xlsx document several times using apache poi 3.7
  21. Apache-POI sorting rows in excel
  22. Java POI : How to read Excel cell value and not the formula computing it?
  23. Edit existing excel files using jxl api / Apache POI
  24. Create a password protected Excel file using Apache POI?
  25. Apache POI evaluate formula
  26. Embed files into XSSF sheets in Excel, using Apache POI
  27. Java POI the supplied data appears to be in the Office 2007+ XML
  28. Determine MS Excel file type with Apache POI
  29. Make column read-only using apache poi
  30. How to call an Excel VBA Macro from Java Code?

Leave a Comment