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: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
