Writing date formats to excel sheets. Not getting formatted properly.

[Chewbacca <ch...@yahoo.com>]

Hello, guys.

I'm using HSSFCell to write date values to excel sheets (is this the write
place to ask? It's not a Core API).

Anyway, here's how my program works. I keep a excel sheet on my server as a
template. The users will generate excel sheets from the server. Based on
their input, the server will first make a new copy of the template. After
this, the server read certain values from the database and write into the
new excel sheet (HSSFCell.setCellValue).

My problem is that the template file already has certain cells formatted for
dates alread (format is dd-MMM-yy). However, when I write the data inside
(which is a string with the same format: dd-MMM-yy), it appears as
mm/dd/yyyy instead.

If I just save the excel sheet, open it up, double click the cell in
question and press enter, the date will be formatted properly.

How do I fix this? Much thanks. 
-- 
View this message in context: http://www.nabble.com/Writing-date-formats-to-excel-sheets.-Not-getting-formatted-properly.-tf2543123.html#a7086092
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/