java poi 设置单元格颜色_【转】关于POI 中单元格背景色设置

最新推荐文章于 2024-07-08 02:39:31 发布
最新推荐文章于 2024-07-08 02:39:31 发布
阅读量317 收藏
点赞数
文章标签： java poi 设置单元格颜色
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_36048031/article/details/114131240
版权
本文展示了如何使用Java的Apache POI库来为Excel单元格设置不同的背景颜色，包括Aqua、Orange、Blue等不同颜色，并通过FillPatternType.SOLID_FOREGROUND填充模式进行设置。
摘要由CSDN通过智能技术生成

/****/

packagecom.totest.poiDemo;importjava.io.FileOutputStream;importjava.io.IOException;importorg.apache.poi.ss.usermodel.Cell;importorg.apache.poi.ss.usermodel.CellStyle;importorg.apache.poi.ss.usermodel.FillPatternType;importorg.apache.poi.ss.usermodel.IndexedColors;importorg.apache.poi.ss.usermodel.Row;importorg.apache.poi.ss.usermodel.Sheet;importorg.apache.poi.ss.usermodel.Workbook;importorg.apache.poi.xssf.usermodel.XSSFWorkbook;public classPOIFillAndColorExample {public static void main(String[] args) throwsIOException {//Create a workbook object

Workbook workbook = newXSSFWorkbook();//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(FillPatternType.SOLID_FOREGROUND);

style.setFillPattern(FillPatternType.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(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X2");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X3");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X4");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.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(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X6");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X7");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X8");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X9");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.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(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X11");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X12");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X13");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X14");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.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(FillPatternType.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(FillPatternType.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(FillPatternType.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(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X19");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.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(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X21");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X22");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X23");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X24");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.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(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X26");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X27");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X28");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X29");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.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(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X31");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X32");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X33");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X34");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.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(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X36");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X37");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X38");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X39");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.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(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X41");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X42");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X43");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X44");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.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(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X46");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X47");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X48");

cell.setCellStyle(style);

style=workbook.createCellStyle();

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

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

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

cell.setCellValue("X49");

cell.setCellStyle(style);//Write the output to a file

FileOutputStream fileOut = newFileOutputStream("POIFillAndColorExample.xlsx");

workbook.write(fileOut);

fileOut.close();

}

}

18125857287
关注
poi设置单元格背景颜色
06-24 4075
Java使用poi可以很方便地导出Excel表格文件，同时可以设置各种样式，例如背景颜色。下面给出两个例子设置背景颜色，一个使用自带的颜色设置背景颜色，一个使用自定义颜色设置。 使用内置的颜色设置单元格背景颜色 准备工作：下载poi插件，并且部署到项目下面，例子使用的是3.17版本。 导出一个人员Excel表格，代码如下，制作例子说明，可以直接复制： public static void main(String[] args) throws IOException { HSS
java导出excel设置单元格样式_java poi批量导出excel 设置单元格样式
weixin_39683163的博客
02-28 1419
POI中可能会用到一些需要设置EXCEL单元格格式的操作小结：先获取工作薄对象:HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet();HSSFCellStyle setBorder = wb.createCellStyle();一、设置背景色：setBorder.setFillForegroundColor(...
Java Poi 导出excel（支持各种设置字体、颜色、垂直居中）
03-01
Java Poi 导出excel（支持各种设置字体、颜色、垂直居中）
java 自定义颜色_JAVA POI 自定义颜色
weixin_36003005的博客
02-18 990
JAVA POI 中使用颜色的类叫: HSSFColor, 它默认提供了几十种常用的颜色,如BLANK; BLUE等, 且许多时候都是使用HSSFColor的index属性值(如 HSSFColor.BLUE.index);但在实际应用中, 这些已经定义的颜色并不能满足需求(如客户给你一个RGB颜色值255,204,153; 并要求导出的Excel中使用这个颜色).我们需要HSSFPalet...
java poi操作excel 背景色
最新发布
weixin_40391111的博客
07-08 84
Excel相关视频讲解：用python编程Excel有没有用处？如何使用Java POI操作Excel背景色 整体流程 首先，让我们来看一下整个操作Excel背景色的流程： 步骤 操作 1 创建一个新的Excel文件 2 创建一个单元格样式对象 3 设置单元格的背景色 4 将样式应用到指定单元格...
Java POI excel单元格背景色(填充)、字体颜色(对齐)、边框(颜色)、行高、列宽设置
扶摇的博客
07-06 2万+
Excel POI设置行高、列宽；单元格背景填充色、字体样式
java使用poi导出excel设置颜色问题
热门推荐
z1074907546的博客
01-19 4万+
POI 设置单元格背景色 cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);//设置前景填充样式 cellStyle.setFillForegroundColor(HSSFColor.DARK_RED.index);//前景填充色 关于颜色的部分说明:   HSSFWorkbook wb = new HSSFWor
POI 设置单元格背景颜色
郴州软件学习www.javaketang.com
12-10 3987
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. ...
java excel单元格背景色_POI 设置Excel单元格背景色（setFillForegroundColor)
weixin_35831969的博客
02-13 4137
背景介绍：使用Java开发信息系统项目，项目中往往会涉及到报表管理部分，而Excel表格首当其冲称为最合适的选择，但是对单元格操作时对于设置单元格的背景颜色却很少提及，本文旨在方便单元格背景颜色设计。操作：至于冗长的创建表格表格设置的代码相信大家都已经了解。直接进行单元格背景颜色设计。1 HSSFCellStyle style =wb.createCellStyle();2 style.setAl...
java poi 设置背景色_使用Apache POI设置Excel单元格的RGB背景颜色
06-10
需要注意的是，使用Apache POI设置背景颜色时，需要使用`XSSFColor`类来创建颜色对象，并将其设置为单元格样式中的前景色。同时，还需要设置填充模式为`SOLID_FOREGROUND`，这样才能正确显示背景颜色。
poi怎么设置某个单元格为下拉框_Java 使用POI生成带联动下拉框的excel表格实例代码...
weixin_39816141的博客
12-19 366
废话不多说了，直接给大家贴代码了，具体代码如下所示：import java.io.File;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.util.ArrayList;import java.util.Arrays;import ...
【JAVA】POI 中单元格背景色设置
℡華ゞ
08-13 2267
颜色盘 /** * */ package com.totest.poiDemo; 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.FillPatternType; impo.
使用poi导出excel设置颜色(JAVA)
weixin_38061311的博客
02-02 4万+
参考文档:https://blog.csdn.net/z1074907546/article/details/50544178 java使用poi导出excel设置颜色 POI 设置单元格背景色 cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);//设置前景填充样式 cellStyle.setFillForegroundColor(...
java POI实现Excel单元格自定义颜色
※老鼠拧刀满街找猫※
01-12 5474
HSSF HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(); HSSFRow row = sheet.createRow((short) 0); HSSFCell cell = row.createCell((short) 0); cell.setCellV
POI 颜色Color
李平安
09-29 1万+
1. 颜色概述颜色Color是单元格的基本样式，单元格默认颜色为黑色 - 单元格边框颜色 - 单元格填充色 - 单元格字体颜色2. 预定自颜色POI中预定义了56种颜色，索引从0x8 - 0x40， 索引0x40定义一种默认颜色 - 黑色org.apache.poi.ss.usermodel.IndexedColors org.apache.poi.hssf.util.HSSFColor$
org.apache.poi 设置 Excel 单元格颜色 RGB
ideal-lingyun
05-01 4992
org.apache.poi 设置 Excel 单元格颜色 RGB
POI颜色设置
qq_41115103的博客
12-06 730
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 IndexedColors 编码与颜色对照
zhpeng289的博客
05-05 9745
使用方法： 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.use...
java poi 设置背景色,Java Apache Poi，如何同时设置背景颜色和边框
weixin_42305992的博客
02-16 281
at start i want to say that i'm totally new in developers world.I tried to generate an excel sheet that contains Mutiplication Table with borders and set background color but only for 1st column and...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值