Styles API POI

Question

Styles API POI

Navigation

#1 by (1 votes)
#2 by (0 votes)

1

I have:

CellStyle style = sheet.getWorkbook().createCellStyle();

HSSFCell cell = row.createCell((short)number);
cell.setCellValue(text)
cell.setCellStyle(style);

I would like the background to be gray, for example

java apache-poi

asked by sirdaiz 28.04.2017 в 12:32

source

2 answers

0

With this method you can add the color.

protected CellStyle setCellBackground(CellStyle cellStyle, Short color) {
    cellStyle.setFillForegroundColor(color);
    cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
    return cellStyle;
}

For the gray color it is:

HSSFColor.GREY_25_PERCENT.index

answered by 31.10.2017 в 00:21

Assign the path of a file to a variable and then use it in FFmpeg CREATE SCHEMA or DATABASE has a difference? and placing the CONSTRAINT before an FK is necessary?

score 1 · Accepted Answer

What you have to do is:

CellStyle style = sheet.getWorkbook().createCellStyle();

//cambiar el fondo
style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
style.setFillPattern(CellStyle.SOLID_FOREGROUND);

HSSFCell cell = row.createCell((short)number);
cell.setCellValue(text)
cell.setCellStyle(style);