You need to set foreground color, not background.
Also, create a cell style outside of the loop:
CellStyle sytle = wb.createCellStyle();
style.setFillForegroundColor(HSSFColor.YELLOW.index);
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
and then assign it to the cells:
while(ct.hasNext()){
Cell cell = (Cell) ct.next();
cell.setCellStyle(style);
}
Yegor
On Tue, Feb 14, 2012 at 1:00 PM, Zongquan Liu <[email protected]> wrote:
> the background color doesn't change when I write the workbook to my native
> file!
>
> Thanks
> -Zongquan Liu
>
>
> -----Original Message-----
> From: Zongquan Liu [mailto:[email protected]]
> Sent: Tuesday, February 14, 2012 4:59 PM
> To: 'POI Users List'
> Subject: How to set the background color of a cell? why my code can't
> work... I need some help!
>
> Hi all,
>
> I use POI 3.7 to create Excel files. However, when I decide to set the
> background of the Excel file with following code:
> FileInputStream ins = new FileInputStream(new
> File("/driver/dir/myfile.xls"));
> Workbook wb = new HSSFWorkbook(ins);
> for(int i=0; i< wb.getNumberOfSheets();i++){
> Sheet sheet = wb.getSheetAt(i);
> if(sheet!=null){
> Row row = sheet.getRow(0);
> Iterator<Cell> ct = row.iterator();
> while(ct.hasNext()){
> Cell cell = (Cell) ct.next();
> if(cell!=null){
> HSSFCellStyle hssfstyle = (HSSFCellStyle)
> cell.getCellStyle();
> hssfstyle.setFillBackgroundColor(HSSFColor.YELLOW.index);
> hssfstyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
> cell.setStyle(hssfstyle);
> }
> }
> }
> }
>
> Thanks
> -Zongquan Liu
>
>
> -----Original Message-----
> From: Thomas Sommer [mailto:[email protected]]
> Sent: Tuesday, February 14, 2012 6:24 AM
> To: POI Users List
> Subject: Re: Read-only access to workbook with protected structure and
> window
>
> I did it.
>
> With POI 3.8 beta 5 it's possible to open protected xls-file for reading
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
