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 POI Dataformat not applied Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "POI Dataformat not applied" Watch "POI Dataformat not applied" New topic
Author

POI Dataformat not applied

Sivaraman Lakshmanan
Ranch Hand

Joined: Aug 02, 2003
Posts: 231
Hi All,
I am using POI to create Excel sheets. Here while creating the cell, I apply the necessary styles for which I applied the dataformat. The excel gets generated fine but I am not seeing the format in the generated sheet.

Please see the sample code below



The excel sheet should display the as "31-Jul-08 22:12" but I could see only "7/31/2008 10:12:43 PM".

Any help on this is very much appreciated.


Regards,
Sivaraman.L
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41598
    
  55
Don't use setCellValue(String), use setCellValue(Date).

That's demonstrated at http://poi.apache.org/hssf/quick-guide.html#CreateDateCells


Ping & DNS - my free Android networking tools app
Sivaraman Lakshmanan
Ranch Hand

Joined: Aug 02, 2003
Posts: 231
Hi Ulf,
Thanks a ton. I was breaking my head all day for this.
 
Consider Paul's rocket mass heater.
 
subject: POI Dataformat not applied