HSSF cell date formatting in java
I have created an Excel sheet using HSSF POI.one column called "Customer delivery date" is there in the excel sheet where only date should be entered.If i enter date in this column as 12/13/11 then system should throw an error as we are excepting the date should be in dd/mm/yyyy. This is not happening because the date entered(12/13/11 ) in sheet is being validated by System date [System date format is mm/dd/yy]and while uploading the sheet ,the value to the java code is being passed as 13-Dec-2011 which is not expected.
Could you suggest the solution how to get the exact value entered in the sheet?
It would be a great help for me if you give any suggestions regarding this issue.
Thanks in advance
Re: HSSF cell date formatting in java
Welcome to the Java Programming Forums.
Can we see your code please? If possible attach an example excel sheet too.
We would need to do some tests.