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
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