I am encountering a problem while displaying dates in Excel using the JExcel API. I have a customized format that displays date from an xml file.
The snippet for this is:
The date is being displayed using DateTime
When an excel file displays this date, it is an hour greater than or less than the expected value. For eg. if the xml file shows the date as
In my excel file, I get this date as
7/16/2009 6:54:38 PM instead of
7/16/2009 8:54:38 PM
Please let me know what more do I need to do? Is it a timezone correction? Any ideas, suggestions would be welcome.
Thanks and Regards,
Prostor Systems, Boulder, CO