• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

POI Dataformat not applied

 
Sivaraman Lakshmanan
Ranch Hand
Posts: 231
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Don't use setCellValue(String), use setCellValue(Date).

That's demonstrated at http://poi.apache.org/hssf/quick-guide.html#CreateDateCells
 
Sivaraman Lakshmanan
Ranch Hand
Posts: 231
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ulf,
Thanks a ton. I was breaking my head all day for this.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic