JAVA poi设置单元格背景颜色

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. }

The generated excel files looks like below images.