Fill whole sheet with the same color in Excel - Apache POI

Question

I'm looking for a way to set the color of the background of an Excel worksheet using Java's Apache POI

Thanks!

score 1 · Answer 1 · edited May 23 '17 at 12:12

1

Try XSSFSheet.setTabColor from the POI Documentation

Edited:

You may need to apply it to each cell / row style.

How to apply background color for the rows in excel sheet using Apache POI?

Another similar example/better explanation here:

excel poi: apply foreground color to blank cells

edited May 23 '17 at 12:12

Community

1
1

answered Sep 05 '12 at 18:07

Mike

3,186
3
26
32

This function sets the color of the tab's background, but not the sheet's one. Thanks anyway, I'll keep on searching for a solution! – biggtor Sep 06 '12 at 08:16
@biggtor Updated the answer. Another Resource: http://obscuredclarity.blogspot.de/2011/12/set-background-color-and-add-border-to.html taken from here: http://stackoverflow.com/questions/12242828/starting-with-apache-poi – Mike Sep 06 '12 at 13:55

score 0 · Answer 2 · answered Sep 10 '12 at 03:52

0

HSSFCellStyle cellStyle = workBook.createCellStyle();
style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
cell.setCellStyle(style);

answered Sep 10 '12 at 03:52

swamy

1,200
10
23

1

have you tested your code? The use want to set the whole sheet,and you just defined a cell style! – flyingfox May 22 '17 at 05:21

Fill whole sheet with the same color in Excel - Apache POI

2 Answers2