java poi 设置背景色_POI 设置单元格背景颜色

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.

86fc471923b53e7462da30b50a24c804.png

  • 0
    点赞
  • 0
    评论
  • 1
    收藏
  • 一键三连
    一键三连
  • 扫一扫,分享海报

表情包
插入表情
评论将由博主筛选后显示,对所有人可见 | 还能输入1000个字符
©️2021 CSDN 皮肤主题: 深蓝海洋 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值