Read cell data which contains a date

Aspose.Cells Product Family
1

I am trying to read data from a cell which contains a date using Java. The cell has a value of "1/15/2010" in the XLS file. Using Java, when I read that cell data as a Calendar object or a String object, it comes in as "1/14/2006". Noticed that this is off by 4 years and 1 day. I have tried using other dates in the Excel file, and they are all off by 4 years and 1 day when read by Java.

Any help in this matter will be greatly appreciated.

Arif Rahman

This message was posted using Aspose.Live 2 Forum
2

Hi Arif,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Well, we have tested your issue with the attached latest version of Aspose.Cells and are unable to reproduce the issue. Please try the attached latest version of Aspose.Cells and if you still face any problem, please share your complete sample code and template file to reproduce the issue and we will check it soon.

Thank you & Best Regards,