How to read a Date column from an Excel sheet using Apache POI

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • GNS
    New Member
    • Jun 2006
    • 1

    How to read a Date column from an Excel sheet using Apache POI

    Hi,

    I have an excel sheet which has a Date column whose cell type is custom d-mmm-yy.
    When i read this excel using apache POI then this column gets read as a numeric cell and returns the big decimal value.

    Is there any way of identifying the cell type to be Date for this custom format?

    thanks,
    GNS
Working...