On Fri, 1 Feb 2008, Vishwa Kumba wrote:
HSSFCell cell = getCell(workSheet, row, col);
cell.setCellValue((Date) value);
HSSFCellStyle cellStyle = workBook.createCellStyle();
cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat(DATE_FORMAT));
You'll probably want to create a custom DataFormat -
workbook.createDataFormat(), the use that to add your custom format
string, and finally use that on the cell styles
See http://poi.apache.org/hssf/quick-guide.html#DataFormats
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]