You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by adile <ai...@gmail.com> on 2012/11/26 11:38:04 UTC

Re: setCellStyleProperty: PropertyName and PropertyValue

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org