Can't Set Fill Color Apache POI Excel Workbook

java colors background apache-poi fill
Richie Episcopo picture Richie Episcopo · Jun 21, 2013 · Viewed 32.6k times · Source

I have scanned this forum over and over and tried every method mentioned on here and still can't get Apache POI to change to fill background color of my excel document.

Here is my code:

errorOccured = true;
XSSFCellStyle cs = workbook.createCellStyle();
cs.setFillBackgroundColor(IndexedColors.RED.getIndex());
row.getCell(0).setCellStyle(cs);

Do you know why this wouldn't work? What is the correct way to get row.getCell(0) to be filled with red (background color)?

Thank you!

Answer

Sankumarsingh picture Sankumarsingh · Jun 22, 2013

Use foreground color instead of Background color. 

 errorOccured = true;
 XSSFCellStyle style = workbook.createCellStyle();
 style.setFillForegroundColor(IndexedColors.RED.getIndex());
 style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
 row.getCell(0).setCellStyle(style);

this will fill the cell background color with RED.

Related questions

How to Change action bar setBackgrounddrawable Color in Android Studio using R.Color in Java File?

I want to Change color of Action Bar using Java code in Android studio, I have color.xml file for color codes android.support.v7.app.ActionBar actionBar = getSupportActionBar(); actionBar.setBackgroundDrawable(new ColorDrawable(getColor(R.color.colorVelocity))); **//<<Error …

Read More
How to print color in console using System.out.println?

How can I print color in console? I want to show data in colors when the processor sends data and in different colors when it receives data.

Read More
How do I set the colour of a label (coloured text) in Java?

How do I set the color of the text of a label? myLabel.setText("Text Color: Red"); myLabel.??? Can I have two seperate colors in one label? For example here: The "Text Color:" to be black and the "Red" to …

Read More