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/

Reply via email to