Hi Hans
i found how to use setCellStyleProperty
example :
HSSFCellUtil.setCellStyleProperty(cell, wb, CellUtil.FILL_FOREGROUND_COLOR,
HSSFColor.VIOLET.index);
HSSFCellUtil.setCellStyleProperty(cell, wb,
CellUtil.FILL_PATTERN,
HSSFCellStyle.SOLID_FOREGROUND);
HSSFCellUtil.setCellStyleProperty(cell, wb,
CellUtil.BORDER_TOP,
(short)1);
HSSFCellUtil.setCellStyleProperty(cell, wb,
CellUtil.BORDER_BOTTOM,
(short)1);
HSSFCellUtil.setCellStyleProperty(cell, wb,
CellUtil.BORDER_LEFT,
(short)1);
HSSFCellUtil.setCellStyleProperty(cell, wb,
CellUtil.BORDER_RIGHT,
(short)1);
HSSFCellUtil.setCellStyleProperty(cell, wb,
CellUtil.ALIGNMENT,
HSSFCellStyle.ALIGN_CENTER);
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/setCellStyleProperty-PropertyName-and-PropertyValue-tp5710619p5711549.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
