How to read a Date column from an Excel sheet using Apache POI
Joined: Jun 21, 2006
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?
Joined: Mar 22, 2005
Hello "GNS GNS"-
Welcome to JavaRanch.
On your way in you may have missed that JavaRanch has a policy on display names, and yours does not comply with it; specifically, a first name and a last name are required. Please adjust it accordingly, which you can do right here. Thanks for your prompt attention to this matter.