File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "POI Dataformat not applied" Watch "POI Dataformat not applied" New topic

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.

Ulf Dittmer

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

That's demonstrated at
Sivaraman Lakshmanan
Ranch Hand

Joined: Aug 02, 2003
Posts: 231
Hi Ulf,
Thanks a ton. I was breaking my head all day for this.
I agree. Here's the link:
subject: POI Dataformat not applied
It's not a secret anymore!