You missed the point. He's not trying to grab a builtin format. He's
creating a format object and asking for the given format. You can do the
following (this is a copy of his code example with one change).
> HSSFCellStyle cs = wb.createCellStyle();
> HSSFDataFormat df = wb.createDataFormat();
> cs.setDataFormat(df.getFormat("m/d/yy h:mm:ss AM/PM"));
Below is a full example that will run and produce a file with a date in the
proper format (this is a merge of the date cell example and the custom data
format example off the web site):
import org.apache.poi.hssf.usermodel.*;
import java.util.*;
import java.io.*;
public class test {
public static void main(String args[]) throws Exception {
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("new sheet");
// Create a row and put some cells in it. Rows are 0 based.
HSSFRow row = sheet.createRow((short)0);
// Create a cell and put a date value in it. The first cell is not
styled
// as a date.
HSSFCell cell = row.createCell((short)0);
cell.setCellValue(new Date());
// we style the second cell as a date (and time). It is important to
// create a new cell style from the workbook otherwise you can end up
// modifying the built in style and effecting not only this cell but
other cells.
HSSFCellStyle cellStyle = wb.createCellStyle();
HSSFDataFormat format = wb.createDataFormat();
cellStyle.setDataFormat(format.getFormat("m/d/yy h:mm:ss AM/PM"));
cell = row.createCell((short)1);
cell.setCellValue(new Date());
cell.setCellStyle(cellStyle);
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
}
}
Shawn
-----Original Message-----
From: Tom [mailto:[EMAIL PROTECTED]
Sent: Friday, October 31, 2003 9:48 AM
To: POI Users List
Subject: Re: Antwort: date value with m/d/yy h:mm:ss AM/PM format
that is exactly the problem. i see a "h:mm:ss AM/PM" format and a
"m/d/yy h:mm" .
both formats have most of but not all the precision/fields that i want.
how can i get a "combined" format?
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "POI Users List" <[EMAIL PROTECTED]>
Sent: Friday, October 31, 2003 12:00 AM
Subject: Antwort: date value with m/d/yy h:mm:ss AM/PM format
>
>
>
>
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
