Hello Everyone, 

I output report to an Excel file and I need to set background color for the cells. But no matter how hard I try, I can't do anything - background color remains white. I ask you to help me with advice on how to solve this problem? Here is a fragment of my code:
 

.....

    var orderCellStyle = oO.createCellStyle(orderFont, 0, 0, 0, 0, 0, 0, 0, 0, Constants.ALIGN_LEFT, Constants.ALIGN_CENTER, 0, 0, Constants.NO_FILL);
    orderCellStyle.setVerticalAlignment(Constants.VERTICAL_TOP);
    orderCellStyle.setWrapText(true);
    orderCellStyle.setBorderBottom(Constants.BORDER_THIN);
    orderCellStyle.setBorderTop(Constants.BORDER_THIN);
    orderCellStyle.setBorderLeft(Constants.BORDER_THIN);
    orderCellStyle.setBorderRight(Constants.BORDER_THIN);
    orderCellStyle.setFillBackgroundColor(10); //10 - for example
......
    sheet1.cell(0,0).setCellValue("Example");
    sheet1.cell(0,0).setCellStyle(orderCellStyle);


All cell appearance settings are applied except for the background color :(  I've also tried changing the parameters in oO.createCellStyle(....), but that doesn't work either.

I hope for your help.

 or register to reply.

Notify Moderator