Hi,
I am trying to fill a cell in excel sheet with a plain color and then write STH
in that cell.
I am trying to use this code but it doesn't work.
HSSFCellStyle styleSet = wb.createCellStyle();
styleSet.setFillBackgroundColor(HSSFColor.TURQUOISE.index);
styleSet.setAlignment(HSSFCellStyle.ALIGN_CENTER);
if I add this line it works but the cell's color would not be plain anymore.
styleSet.setFillPattern(HSSFCellStyle.LEAST_DOTS);
Could you please tell me how can I do such a thing.
Best,
Nazanin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/