File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other Open Source Projects and the fly likes Encountering a DateTime problem while displaying a date using Jexcel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Encountering a DateTime problem while displaying a date using Jexcel " Watch "Encountering a DateTime problem while displaying a date using Jexcel " New topic
Author

Encountering a DateTime problem while displaying a date using Jexcel

Minotee Joshi
Greenhorn

Joined: Jul 20, 2009
Posts: 1
Hello,
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
<lastSuccessfulSystemCartridgeBackup>2009-07-16T20:54:38-04:00</lastSuccessfulSystemCartridgeBackup>

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,
Minotee Joshi
Support Engineer
Prostor Systems, Boulder, CO


Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19680
    
  19

Moving to Other Open Source Projects.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Encountering a DateTime problem while displaying a date using Jexcel