Hello,
I use it this way:
HSSFCellStyle cs = wb.createCellStyle();
HSSFDataFormat df = wb.createDataFormat();
cs.setDataFormat(df.getFormat("dd.MM.yyyy"));
Though you have to find a string representing your "m/d/yy h:mm:ss AM/PM"
format.
Hope this helps.
Regards,
Andrew
|---------+--------------------------->
| | |
| | |
| | |
| | |
| | |
| | |
| | "Tom" |
| | <[EMAIL PROTECTED]> |
| | Received : 31.10.2003 |
| | 03:26 |
| | Bitte antworten an "POI |
| | Users List" |
| | |
|---------+--------------------------->
>-------------------------------------------------------------------------------------------------------------------------------|
|
|
|
|
| An: <[EMAIL PROTECTED]>
|
| Kopie:
|
| Thema: date value with m/d/yy h:mm:ss AM/PM format
|
>-------------------------------------------------------------------------------------------------------------------------------|
i would like to wite write a date value to a cell with "m/d/yy h:mm:ss AM/PM"
format. i dont see such a format available in the builtinFormats. how can i use
either user-defined-formats or composite formats?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]