Howdy,
First let me say what a cool product POI is...I've only been using it a
couple of hours, with some some amazing(ly easy) results!
I've run into a slight snag, and searching the archives has not yielded an
answer yet. The problem I'm having is that the dates displayed in Excel are:
- 1 calendar day ahead
- and 4 years ahead
Ahead of what i'm expecting, that is ;-) I use this code snippet to insert
Date values into cells:
HSSFRow header = sheet.getRow((short) 0);
header.createCell((short) 0).setCellValue(aDate);
Of course I also create a date style, and set the cell style to that.
So for example, this is some debugging (toString) for 3 dates:
Sat Nov 01 00:00:00 CST 2003
Sat Nov 15 00:00:00 CST 2003
Sun Nov 16 00:00:00 CST 2003
And here is what shows up in Excel (in both the cell and formula bar):
11/2/07
11/16/07
11/17/07
I have a feeling it has something to do with interpreting the zero's for
time (which day does midnight belong to...), but I have no clue what the
problem could be for the year offset.
Any input would be greatly appreciated. Thank you!
-Sasha Borodin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
