How to read Excel cell having Date with Apache POI?

by

NOTE: HSSFDateUtil is deprecated

If you know which cell i.e. column position say 0 in each row is going to be a date, you can go for
row.getCell(0).getDateCellValue() directly.
http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFCell.html#getDateCellValue()

UPDATE: Here is an example – you can apply this in your switch case code above. I am checking and printing the Numeric as well as Date value. In this case the first column in my sheet has dates, hence I use row.getCell(0).

You can use the if (HSSFDateUtil.isCellDateFormatted .. code block directly in your switch case.

if (row.getCell(0).getCellType() == HSSFCell.CELL_TYPE_NUMERIC)
    System.out.println ("Row No.: " + row.getRowNum ()+ " " +
        row.getCell(0).getNumericCellValue());

    if (HSSFDateUtil.isCellDateFormatted(row.getCell(0))) {
        System.out.println ("Row No.: " + row.getRowNum ()+ " " + 
            row.getCell(0).getDateCellValue());
    }
}

The output is 

Row No.: 0 39281.0
Row No.: 0 Wed Jul 18 00:00:00 IST 2007
Row No.: 1 39491.0
Row No.: 1 Wed Feb 13 00:00:00 IST 2008
Row No.: 2 39311.0
Row No.: 2 Fri Aug 17 00:00:00 IST 2007

More Related Contents:

  1. Apache poi Excel line chart points
  2. Removing a row from an Excel sheet with Apache POI HSSF
  3. Apache POI autoSizeColumn Resizes Incorrectly
  4. How can I read numeric strings in Excel cells as string (not numbers)?
  5. Best language to parse extremely large Excel 2007 files [closed]
  6. Docx to Pdf Converter in java
  7. Embed files into Excel using Apache POI
  8. Apache POI – FileInputStream works, File object fails (NullPointerException)
  9. Apache POI add a Series name into LineChart
  10. How to set axis’ labels in a Line Chart using Apache Poi
  11. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  12. Merging cells in Excel using Apache POI
  13. How to get an Excel Blank Cell Value in Apache POI?
  14. Password Protected Excel File
  15. how to read exact cell content of excel file in apache POI
  16. Create Bar Chart in Excel with Apache POI
  17. Trying to make simple PDF document 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. Create a password protected Excel file using Apache POI?
  24. apache POI java.lang.NoClassDefFoundError: org/apache/commons/compress/archivers/zip/ZipFile
  25. Embed files into XSSF sheets in Excel, using Apache POI
  26. Apache POI Line Chart colors
  27. Determine MS Excel file type with Apache POI
  28. Make column read-only using apache poi
  29. Reading data from xlsx with Apache POI’s SXSSFSheet
  30. How can I access password protected Excel workbook in Java using POI api

Leave a Comment