poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rohan Grover" <rgro...@fisci.com>
Subject FW: Formatting a cell as date while preserving other formatting associated with that cell.
Date Wed, 08 Dec 2010 21:14:42 GMT

Hello all,


I am trying to update a Cell in a Sheet in a XSSFWorkbook with
GregorianCalendar value. The cell is already formatted with an inbuilt
'Format as table' style. I know I have to setDataFormat for that cell to get
the date displayed as 'm/d/yy h:mm' and I would like to do that while
preserving other formatting  the cell carries from the 'Format as table'
style.  Below I provide a Pseudo code for the approach I have tried and its
result. I have not been successfully is achieving my goal. I was hoping
someone would have done something similar. Any help is greatly appreciated.



Workbook templateWorkBook = WorkbookFactory.create(new

Sheet sheet = templateWorkBook.getSheetAt(0);

Row row = sheet.getRow(0)

Cell cell = row.getCell(0,Row.CREATE_NULL_AS_BLANK);


GregorianCalendar calendarObj = new GregorianCalendar();


XSSFCellStyle dateCellStyle =








Though the above code sets the display format of that cell as "m/d/yy h:mm",
it deletes the rest of the formatting associated with that cell.I have tried
setting the cell value only, i.e without formatting it as "m/d/yy h:mm", and
the other formatting stays with the cell but the date is displayed as
numeric value.  Again, any help is greatly appreciated.


-Rohan Grover


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message