===转载：https://www.cnblogs.com/yanjie-java/p/8329631.html
====
POI IndexedColors 编码 与 颜色 对照
1 package com.java.connect.poi;
2
3 import java.io.FileOutputStream;
4 import java.io.IOException;
5
6 import org.apache.poi.ss.usermodel.Cell;
7 import org.apache.poi.ss.usermodel.CellStyle;
8 import org.apache.poi.ss.usermodel.IndexedColors;
9 import org.apache.poi.ss.usermodel.Row;
10 import org.apache.poi.ss.usermodel.Sheet;
11 import org.apache.poi.ss.usermodel.Workbook;
12 import org.apache.poi.xssf.usermodel.XSSFWorkbook;
13
14 public class POIFillAndColorExample {
15 public static void main(String[] args)
throws IOException {
16 // Create a workbook object
17 Workbook workbook =
new XSSFWorkbook();
18 // Create sheet
19 Sheet sheet =
workbook.createSheet();
20
21 // Create a row and put some cells in it.
22 Row row = sheet.createRow((
short) 1
);
23
24 // Aqua background
25 CellStyle style =
workbook.createCellStyle();
26 style.setFillForegroundColor(IndexedColors.AQUA.getIndex());
27 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
28 Cell cell = row.createCell((
short) 1
);
29 cell.setCellValue("X1"
);
30 cell.setCellStyle(style);
31
32 // Orange "foreground", foreground being the fill foreground not the
33 // font color.
34 style =
workbook.createCellStyle();
35 style.setFillForegroundColor(IndexedColors.AUTOMATIC.getIndex());
36 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
37 cell = row.createCell((
short) 2
);
38 cell.setCellValue("X2"
);
39 cell.setCellStyle(style);
40
41 style =
workbook.createCellStyle();
42 style.setFillForegroundColor(IndexedColors.BLUE.getIndex());
43 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
44 cell = row.createCell((
short) 3
);
45 cell.setCellValue("X3"
);
46 cell.setCellStyle(style);
47
48 style =
workbook.createCellStyle();
49 style.setFillForegroundColor(IndexedColors.BLUE_GREY.getIndex());
50 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
51 cell = row.createCell((
short) 4
);
52 cell.setCellValue("X4"
);
53 cell.setCellStyle(style);
54
55 style =
workbook.createCellStyle();
56 style.setFillForegroundColor(IndexedColors.BRIGHT_GREEN.getIndex());
57 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
58 cell = row.createCell((
short) 5
);
59 cell.setCellValue("X5"
);
60 cell.setCellStyle(style);
61
62 // Create a row and put some cells in it.
63 Row row2 = sheet.createRow((
short) 2
);
64
65 style =
workbook.createCellStyle();
66 style.setFillForegroundColor(IndexedColors.BROWN.getIndex());
67 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
68 cell = row2.createCell((
short) 1
);
69 cell.setCellValue("X6"
);
70 cell.setCellStyle(style);
71
72 style =
workbook.createCellStyle();
73 style.setFillForegroundColor(IndexedColors.CORAL.getIndex());
74 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
75 cell = row2.createCell((
short) 2
);
76 cell.setCellValue("X7"
);
77 cell.setCellStyle(style);
78
79 style =
workbook.createCellStyle();
80 style.setFillForegroundColor(IndexedColors.CORNFLOWER_BLUE.getIndex());
81 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
82 cell = row2.createCell((
short) 3
);
83 cell.setCellValue("X8"
);
84 cell.setCellStyle(style);
85
86 style =
workbook.createCellStyle();
87 style.setFillForegroundColor(IndexedColors.DARK_BLUE.getIndex());
88 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
89 cell = row2.createCell((
short) 4
);
90 cell.setCellValue("X9"
);
91 cell.setCellStyle(style);
92 style =
workbook.createCellStyle();
93 style.setFillForegroundColor(IndexedColors.DARK_GREEN.getIndex());
94 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
95 cell = row2.createCell((
short) 5
);
96 cell.setCellValue("X10"
);
97 cell.setCellStyle(style);
98
99 // Create a row and put some cells in it.
100 Row row3 = sheet.createRow((
short) 3
);
101
102 style =
workbook.createCellStyle();
103 style.setFillForegroundColor(IndexedColors.DARK_RED.getIndex());
104 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
105 cell = row3.createCell((
short) 1
);
106 cell.setCellValue("X11"
);
107 cell.setCellStyle(style);
108 style =
workbook.createCellStyle();
109 style.setFillForegroundColor(IndexedColors.DARK_TEAL.getIndex());
110 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
111 cell = row3.createCell((
short) 2
);
112 cell.setCellValue("X12"
);
113 cell.setCellStyle(style);
114
115 style =
workbook.createCellStyle();
116 style.setFillForegroundColor(IndexedColors.DARK_YELLOW.getIndex());
117 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
118 cell = row3.createCell((
short) 3
);
119 cell.setCellValue("X13"
);
120 cell.setCellStyle(style);
121 style =
workbook.createCellStyle();
122 style.setFillForegroundColor(IndexedColors.GOLD.getIndex());
123 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
124 cell = row3.createCell((
short) 4
);
125 cell.setCellValue("X14"
);
126 cell.setCellStyle(style);
127
128 style =
workbook.createCellStyle();
129 style.setFillForegroundColor(IndexedColors.GREEN.getIndex());
130 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
131 cell = row3.createCell((
short) 5
);
132 cell.setCellValue("X15"
);
133 cell.setCellStyle(style);
134
135 // Create a row and put some cells in it.
136 Row row4 = sheet.createRow((
short) 4
);
137 style =
workbook.createCellStyle();
138 style.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
139 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
140 cell = row4.createCell((
short) 1
);
141 cell.setCellValue("X16"
);
142 cell.setCellStyle(style);
143
144 style =
workbook.createCellStyle();
145 style.setFillForegroundColor(IndexedColors.GREY_40_PERCENT.getIndex());
146 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
147 cell = row4.createCell((
short) 2
);
148 cell.setCellValue("X17"
);
149 cell.setCellStyle(style);
150 style =
workbook.createCellStyle();
151 style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex());
152 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
153 cell = row4.createCell((
short) 3
);
154 cell.setCellValue("X18"
);
155 cell.setCellStyle(style);
156
157 style =
workbook.createCellStyle();
158 style.setFillForegroundColor(IndexedColors.GREY_80_PERCENT.getIndex());
159 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
160 cell = row4.createCell((
short) 4
);
161 cell.setCellValue("X19"
);
162 cell.setCellStyle(style);
163 style =
workbook.createCellStyle();
164 style.setFillForegroundColor(IndexedColors.INDIGO.getIndex());
165 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
166 cell = row4.createCell((
short) 5
);
167 cell.setCellValue("X20"
);
168 cell.setCellStyle(style);
169
170 // Create a row and put some cells in it.
171 Row row5 = sheet.createRow((
short) 5
);
172
173 style =
workbook.createCellStyle();
174 style.setFillForegroundColor(IndexedColors.LAVENDER.getIndex());
175 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
176 cell = row5.createCell((
short) 1
);
177 cell.setCellValue("X21"
);
178 cell.setCellStyle(style);
179
180 style =
workbook.createCellStyle();
181 style.setFillForegroundColor(IndexedColors.LEMON_CHIFFON.getIndex());
182 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
183 cell = row5.createCell((
short) 2
);
184 cell.setCellValue("X22"
);
185 cell.setCellStyle(style);
186
187 style =
workbook.createCellStyle();
188 style.setFillForegroundColor(IndexedColors.LIGHT_BLUE.getIndex());
189 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
190 cell = row5.createCell((
short) 3
);
191 cell.setCellValue("X23"
);
192 cell.setCellStyle(style);
193 style =
workbook.createCellStyle();
194 style.setFillForegroundColor(IndexedColors.LEMON_CHIFFON.getIndex());
195 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
196 cell = row5.createCell((
short) 4
);
197 cell.setCellValue("X24"
);
198 cell.setCellStyle(style);
199
200 style =
workbook.createCellStyle();
201 style.setFillForegroundColor(IndexedColors.LIGHT_BLUE.getIndex());
202 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
203 cell = row5.createCell((
short) 5
);
204 cell.setCellValue("X25"
);
205 cell.setCellStyle(style);
206
207 // Create a row and put some cells in it.
208 Row row6 = sheet.createRow((
short) 6
);
209 style =
workbook.createCellStyle();
210 style.setFillForegroundColor(IndexedColors.LIGHT_CORNFLOWER_BLUE
211 .getIndex());
212 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
213 cell = row6.createCell((
short) 1
);
214 cell.setCellValue("X26"
);
215 cell.setCellStyle(style);
216
217 style =
workbook.createCellStyle();
218 style.setFillForegroundColor(IndexedColors.LIGHT_GREEN.getIndex());
219 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
220 cell = row6.createCell((
short) 2
);
221 cell.setCellValue("X27"
);
222 cell.setCellStyle(style);
223 style =
workbook.createCellStyle();
224 style.setFillForegroundColor(IndexedColors.LIGHT_ORANGE.getIndex());
225 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
226 cell = row6.createCell((
short) 3
);
227 cell.setCellValue("X28"
);
228 cell.setCellStyle(style);
229
230 style =
workbook.createCellStyle();
231 style.setFillForegroundColor(IndexedColors.LIGHT_TURQUOISE.getIndex());
232 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
233 cell = row6.createCell((
short) 4
);
234 cell.setCellValue("X29"
);
235 cell.setCellStyle(style);
236
237 style =
workbook.createCellStyle();
238 style.setFillForegroundColor(IndexedColors.LIGHT_YELLOW.getIndex());
239 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
240 cell = row6.createCell((
short) 5
);
241 cell.setCellValue("X30"
);
242 cell.setCellStyle(style);
243
244 // Create a row and put some cells in it.
245 Row row7 = sheet.createRow((
short) 7
);
246 style =
workbook.createCellStyle();
247 style.setFillForegroundColor(IndexedColors.LIME.getIndex());
248 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
249 cell = row7.createCell((
short) 1
);
250 cell.setCellValue("X31"
);
251 cell.setCellStyle(style);
252 style =
workbook.createCellStyle();
253 style.setFillForegroundColor(IndexedColors.MAROON.getIndex());
254 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
255 cell = row7.createCell((
short) 2
);
256 cell.setCellValue("X32"
);
257 cell.setCellStyle(style);
258
259 style =
workbook.createCellStyle();
260 style.setFillForegroundColor(IndexedColors.OLIVE_GREEN.getIndex());
261 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
262 cell = row7.createCell((
short) 3
);
263 cell.setCellValue("X33"
);
264 cell.setCellStyle(style);
265 style =
workbook.createCellStyle();
266 style.setFillForegroundColor(IndexedColors.ORANGE.getIndex());
267 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
268 cell = row7.createCell((
short) 4
);
269 cell.setCellValue("X34"
);
270 cell.setCellStyle(style);
271
272 style =
workbook.createCellStyle();
273 style.setFillForegroundColor(IndexedColors.ORCHID.getIndex());
274 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
275 cell = row7.createCell((
short) 5
);
276 cell.setCellValue("X35"
);
277 cell.setCellStyle(style);
278
279 // Create a row and put some cells in it.
280 Row row8 = sheet.createRow((
short) 8
);
281
282 style =
workbook.createCellStyle();
283 style.setFillForegroundColor(IndexedColors.PALE_BLUE.getIndex());
284 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
285 cell = row8.createCell((
short) 1
);
286 cell.setCellValue("X36"
);
287 cell.setCellStyle(style);
288
289 style =
workbook.createCellStyle();
290 style.setFillForegroundColor(IndexedColors.PINK.getIndex());
291 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
292 cell = row8.createCell((
short) 2
);
293 cell.setCellValue("X37"
);
294 cell.setCellStyle(style);
295 style =
workbook.createCellStyle();
296 style.setFillForegroundColor(IndexedColors.PLUM.getIndex());
297 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
298 cell = row8.createCell((
short) 3
);
299 cell.setCellValue("X38"
);
300 cell.setCellStyle(style);
301
302 style =
workbook.createCellStyle();
303 style.setFillForegroundColor(IndexedColors.RED.getIndex());
304 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
305 cell = row8.createCell((
short) 4
);
306 cell.setCellValue("X39"
);
307 cell.setCellStyle(style);
308 style =
workbook.createCellStyle();
309 style.setFillForegroundColor(IndexedColors.ROSE.getIndex());
310 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
311 cell = row8.createCell((
short) 5
);
312 cell.setCellValue("X40"
);
313 cell.setCellStyle(style);
314
315 // Create a row and put some cells in it.
316 Row row9 = sheet.createRow((
short) 9
);
317
318 style =
workbook.createCellStyle();
319 style.setFillForegroundColor(IndexedColors.ROYAL_BLUE.getIndex());
320 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
321 cell = row9.createCell((
short) 1
);
322 cell.setCellValue("X41"
);
323 cell.setCellStyle(style);
324 style =
workbook.createCellStyle();
325 style.setFillForegroundColor(IndexedColors.SEA_GREEN.getIndex());
326 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
327 cell = row9.createCell((
short) 2
);
328 cell.setCellValue("X42"
);
329 cell.setCellStyle(style);
330
331 style =
workbook.createCellStyle();
332 style.setFillForegroundColor(IndexedColors.SKY_BLUE.getIndex());
333 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
334 cell = row9.createCell((
short) 3
);
335 cell.setCellValue("X43"
);
336 cell.setCellStyle(style);
337 style =
workbook.createCellStyle();
338 style.setFillForegroundColor(IndexedColors.TAN.getIndex());
339 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
340 cell = row9.createCell((
short) 4
);
341 cell.setCellValue("X44"
);
342 cell.setCellStyle(style);
343
344 style =
workbook.createCellStyle();
345 style.setFillForegroundColor(IndexedColors.TEAL.getIndex());
346 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
347 cell = row9.createCell((
short) 5
);
348 cell.setCellValue("X45"
);
349 cell.setCellStyle(style);
350
351 // Create a row and put some cells in it.
352 Row row10 = sheet.createRow((
short) 10
);
353
354 style =
workbook.createCellStyle();
355 style.setFillForegroundColor(IndexedColors.TURQUOISE.getIndex());
356 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
357 cell = row10.createCell((
short) 1
);
358 cell.setCellValue("X46"
);
359 cell.setCellStyle(style);
360
361 style =
workbook.createCellStyle();
362 style.setFillForegroundColor(IndexedColors.VIOLET.getIndex());
363 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
364 cell = row10.createCell((
short) 2
);
365 cell.setCellValue("X47"
);
366 cell.setCellStyle(style);
367 style =
workbook.createCellStyle();
368 style.setFillForegroundColor(IndexedColors.WHITE.getIndex());
369 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
370 cell = row10.createCell((
short) 3
);
371 cell.setCellValue("X48"
);
372 cell.setCellStyle(style);
373
374 style =
workbook.createCellStyle();
375 style.setFillForegroundColor(IndexedColors.YELLOW.getIndex());
376 style.setFillPattern(CellStyle.SOLID_FOREGROUND);
377 cell = row10.createCell((
short) 3
);
378 cell.setCellValue("X49"
);
379 cell.setCellStyle(style);
380
381 // Write the output to a file
382 FileOutputStream fileOut =
new FileOutputStream(
383 "POIFillAndColorExample.xlsx"
);
384 workbook.write(fileOut);
385 fileOut.close();
386
387 }
388 }
生成的excel文件看起来像下面的图片。
colororg.apache.poi.hssf.util.HSSFColor$GREY_80_PERCENT@1aadbf7colororg.apache.poi.hssf.util.HSSFColor$INDIGO@4f4458colororg.apache.poi.hssf.util.HSSFColor$PLUM@100c56colororg.apache.poi.hssf.util.HSSFColor$BROWN@19a1faecolororg.apache.poi.hssf.util.HSSFColor$OLIVE_GREEN@1960c9ecolororg.apache.poi.hssf.util.HSSFColor$DARK_GREEN@168f39colororg.apache.poi.hssf.util.HSSFColor$SEA_GREEN@11525cdcolororg.apache.poi.hssf.util.HSSFColor$DARK_TEAL@164e67fcolororg.apache.poi.hssf.util.HSSFColor$GREY_40_PERCENT@158cfdacolororg.apache.poi.hssf.util.HSSFColor$BLUE_GREY@1b613c0colororg.apache.poi.hssf.util.HSSFColor$ORANGE@cae1b3colororg.apache.poi.hssf.util.HSSFColor$LIGHT_ORANGE@1a7e798colororg.apache.poi.hssf.util.HSSFColor$GOLD@55d1efcolororg.apache.poi.hssf.util.HSSFColor$LIME@49b9adcolororg.apache.poi.hssf.util.HSSFColor$AQUA@3d0f0ecolororg.apache.poi.hssf.util.HSSFColor$LIGHT_BLUE@a7624ecolororg.apache.poi.hssf.util.HSSFColor$TAN@1271218colororg.apache.poi.hssf.util.HSSFColor$LAVENDER@150b2dcolororg.apache.poi.hssf.util.HSSFColor$ROSE@190c9dccolororg.apache.poi.hssf.util.HSSFColor$PALE_BLUE@b4bc8ecolororg.apache.poi.hssf.util.HSSFColor$LIGHT_YELLOW@1c74456colororg.apache.poi.hssf.util.HSSFColor$LIGHT_GREEN@15783a2colororg.apache.poi.hssf.util.HSSFColor$LIGHT_TURQUOISE@830993colororg.apache.poi.hssf.util.HSSFColor$SKY_BLUE@e99642colororg.apache.poi.hssf.util.HSSFColor$BLUE@187f194colororg.apache.poi.hssf.util.HSSFColor$TEAL@55f9fcolororg.apache.poi.hssf.util.HSSFColor$DARK_RED@c8e08fcolororg.apache.poi.hssf.util.HSSFColor$VIOLET@edd19colororg.apache.poi.hssf.util.HSSFColor$TURQUOISE@1d5c7a1colororg.apache.poi.hssf.util.HSSFColor$YELLOW@252119colororg.apache.poi.hssf.util.HSSFColor$PINK@19ff062colororg.apache.poi.hssf.util.HSSFColor$DARK_BLUE@15eb4d0colororg.apache.poi.hssf.util.HSSFColor$LIGHT_CORNFLOWER_BLUE@b0e84bcolororg.apache.poi.hssf.util.HSSFColor$ROYAL_BLUE@62a19dcolororg.apache.poi.hssf.util.HSSFColor$CORAL@16075b3colororg.apache.poi.hssf.util.HSSFColor$ORCHID@1cf46c2colororg.apache.poi.hssf.util.HSSFColor$LIGHT_TURQUOISE@12e8a41colororg.apache.poi.hssf.util.HSSFColor$LEMON_CHIFFON@76ec7acolororg.apache.poi.hssf.util.HSSFColor$PLUM@19f7952colororg.apache.poi.hssf.util.HSSFColor$CORNFLOWER_BLUE@d60cddcolororg.apache.poi.hssf.util.HSSFColor$GREY_50_PERCENT@e6bc11colororg.apache.poi.hssf.util.HSSFColor$GREY_25_PERCENT@452267colororg.apache.poi.hssf.util.HSSFColor$TEAL@d5b614colororg.apache.poi.hssf.util.HSSFColor$VIOLET@a4e3ae
colororg.apache.poi.hssf.util.HSSFColor$DARK_YELLOW@15fd4a3colororg.apache.poi.hssf.util.HSSFColor$DARK_BLUE@8137c9colororg.apache.poi.hssf.util.HSSFColor$GREEN@1757596colororg.apache.poi.hssf.util.HSSFColor$DARK_RED@7ad4d5colororg.apache.poi.hssf.util.HSSFColor$TURQUOISE@2aee3fcolororg.apache.poi.hssf.util.HSSFColor$PINK@7f788bcolororg.apache.poi.hssf.util.HSSFColor$YELLOW@c311d5colororg.apache.poi.hssf.util.HSSFColor$BLUE@c7e580colororg.apache.poi.hssf.util.HSSFColor$BRIGHT_GREEN@1ac55accolororg.apache.poi.hssf.util.HSSFColor$RED@12cc460colororg.apache.poi.hssf.util.HSSFColor$WHITE@10ad7ecolororg.apache.poi.hssf.util.HSSFColor$BLACK@ee336f
分类:
java Excel导入导出相关
