Setting foreground color for HSSFCellStyle is always coming out black
Posted
by Ascalonian
on Stack Overflow
See other posts from Stack Overflow
or by Ascalonian
Published on 2010-05-10T15:21:01Z
Indexed on
2010/05/10
15:24 UTC
Read the original article
Hit count: 302
I am using POI to create an Excel spreadsheet in Java. I have the following code used for creating a header row:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Report");
// some more code
HSSFRow row = sheet.createRow(0);
HSSFCell cell = row.createCell(cellNumber);
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setFillBackgroundColor(HSSFColor.GREY_25_PERCENT.index);
cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
HSSFFont font = wb.createFont();
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
font.setColor(HSSFColor.WHITE.index);
cellStyle.setFont(font);
cell.setCellStyle(cellStyle);
The issue I am having is that setting the fill background color on the cell always comes out black, no matter what color I pick. What am I doing wrong? If I don't use the "setFillPattern" line, no color shows up at all.
© Stack Overflow or respective owner