pio 背景色

This example shows you Excel cell fills and colors using Apache POI.

In our example i have used all the possible colors and set it as Fills background colors of cells.

Below is the example code.

package com.java.connect.poi;

import java.io.FileOutputStream;

import java.io.IOException;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.CellStyle;

import org.apache.poi.ss.usermodel.IndexedColors;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class POIFillAndColorExample {

	public static void main(String[] args) throws IOException {

		// Create a workbook object

		Workbook workbook = new XSSFWorkbook();

		// Create sheet

		Sheet sheet = workbook.createSheet();

		// Create a row and put some cells in it.

		Row row = sheet.createRow((short) 1);

		// Aqua background

		CellStyle style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.AQUA.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		Cell cell = row.createCell((short) 1);

		cell.setCellValue("X1");

		cell.setCellStyle(style);

		// Orange "foreground", foreground being the fill foreground not the

		// font color.

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.AUTOMATIC.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row.createCell((short) 2);

		cell.setCellValue("X2");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.BLUE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row.createCell((short) 3);

		cell.setCellValue("X3");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.BLUE_GREY.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row.createCell((short) 4);

		cell.setCellValue("X4");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.BRIGHT_GREEN.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row.createCell((short) 5);

		cell.setCellValue("X5");

		cell.setCellStyle(style);

		// Create a row and put some cells in it.

		Row row2 = sheet.createRow((short) 2);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.BROWN.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row2.createCell((short) 1);

		cell.setCellValue("X6");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.CORAL.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row2.createCell((short) 2);

		cell.setCellValue("X7");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.CORNFLOWER_BLUE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row2.createCell((short) 3);

		cell.setCellValue("X8");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.DARK_BLUE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row2.createCell((short) 4);

		cell.setCellValue("X9");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.DARK_GREEN.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row2.createCell((short) 5);

		cell.setCellValue("X10");

		cell.setCellStyle(style);

		// Create a row and put some cells in it.

		Row row3 = sheet.createRow((short) 3);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.DARK_RED.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row3.createCell((short) 1);

		cell.setCellValue("X11");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.DARK_TEAL.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row3.createCell((short) 2);

		cell.setCellValue("X12");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.DARK_YELLOW.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row3.createCell((short) 3);

		cell.setCellValue("X13");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.GOLD.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row3.createCell((short) 4);

		cell.setCellValue("X14");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.GREEN.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row3.createCell((short) 5);

		cell.setCellValue("X15");

		cell.setCellStyle(style);

		// Create a row and put some cells in it.

		Row row4 = sheet.createRow((short) 4);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row4.createCell((short) 1);

		cell.setCellValue("X16");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.GREY_40_PERCENT.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row4.createCell((short) 2);

		cell.setCellValue("X17");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row4.createCell((short) 3);

		cell.setCellValue("X18");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.GREY_80_PERCENT.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row4.createCell((short) 4);

		cell.setCellValue("X19");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.INDIGO.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row4.createCell((short) 5);

		cell.setCellValue("X20");

		cell.setCellStyle(style);

		// Create a row and put some cells in it.

		Row row5 = sheet.createRow((short) 5);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LAVENDER.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row5.createCell((short) 1);

		cell.setCellValue("X21");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LEMON_CHIFFON.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row5.createCell((short) 2);

		cell.setCellValue("X22");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LIGHT_BLUE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row5.createCell((short) 3);

		cell.setCellValue("X23");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LEMON_CHIFFON.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row5.createCell((short) 4);

		cell.setCellValue("X24");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LIGHT_BLUE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row5.createCell((short) 5);

		cell.setCellValue("X25");

		cell.setCellStyle(style);

		// Create a row and put some cells in it.

		Row row6 = sheet.createRow((short) 6);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LIGHT_CORNFLOWER_BLUE

				.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row6.createCell((short) 1);

		cell.setCellValue("X26");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LIGHT_GREEN.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row6.createCell((short) 2);

		cell.setCellValue("X27");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LIGHT_ORANGE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row6.createCell((short) 3);

		cell.setCellValue("X28");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LIGHT_TURQUOISE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row6.createCell((short) 4);

		cell.setCellValue("X29");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LIGHT_YELLOW.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row6.createCell((short) 5);

		cell.setCellValue("X30");

		cell.setCellStyle(style);

		// Create a row and put some cells in it.

		Row row7 = sheet.createRow((short) 7);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.LIME.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row7.createCell((short) 1);

		cell.setCellValue("X31");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.MAROON.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row7.createCell((short) 2);

		cell.setCellValue("X32");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.OLIVE_GREEN.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row7.createCell((short) 3);

		cell.setCellValue("X33");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.ORANGE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row7.createCell((short) 4);

		cell.setCellValue("X34");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.ORCHID.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row7.createCell((short) 5);

		cell.setCellValue("X35");

		cell.setCellStyle(style);

		// Create a row and put some cells in it.

		Row row8 = sheet.createRow((short) 8);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.PALE_BLUE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row8.createCell((short) 1);

		cell.setCellValue("X36");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.PINK.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row8.createCell((short) 2);

		cell.setCellValue("X37");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.PLUM.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row8.createCell((short) 3);

		cell.setCellValue("X38");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.RED.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row8.createCell((short) 4);

		cell.setCellValue("X39");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.ROSE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row8.createCell((short) 5);

		cell.setCellValue("X40");

		cell.setCellStyle(style);

		// Create a row and put some cells in it.

		Row row9 = sheet.createRow((short) 9);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.ROYAL_BLUE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row9.createCell((short) 1);

		cell.setCellValue("X41");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.SEA_GREEN.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row9.createCell((short) 2);

		cell.setCellValue("X42");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.SKY_BLUE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row9.createCell((short) 3);

		cell.setCellValue("X43");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.TAN.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row9.createCell((short) 4);

		cell.setCellValue("X44");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.TEAL.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row9.createCell((short) 5);

		cell.setCellValue("X45");

		cell.setCellStyle(style);

		// Create a row and put some cells in it.

		Row row10 = sheet.createRow((short) 10);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.TURQUOISE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row10.createCell((short) 1);

		cell.setCellValue("X46");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.VIOLET.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row10.createCell((short) 2);

		cell.setCellValue("X47");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.WHITE.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row10.createCell((short) 3);

		cell.setCellValue("X48");

		cell.setCellStyle(style);

		style = workbook.createCellStyle();

		style.setFillForegroundColor(IndexedColors.YELLOW.getIndex());

		style.setFillPattern(CellStyle.SOLID_FOREGROUND);

		cell = row10.createCell((short) 3);

		cell.setCellValue("X49");

		cell.setCellStyle(style);

		// Write the output to a file

		FileOutputStream fileOut = new FileOutputStream(

				"POIFillAndColorExample.xlsx");

		workbook.write(fileOut);

		fileOut.close();

	}

}

The generated excel files looks like below images.