|
POI中背景颜色设置方法如下:
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setFillBackgroundColor(HSSFColor.TEAL.index); //设置背景色
cellStyle.setFillForegroundColor(HSSFColor.TEAL.index);// 设置前景色
cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
附：HSSFColor颜色定义
| 色 |
执行结果 |
| HSSFColor.ROYAL_BLUE |
? |
| HSSFColor.TEAL |
? |
| HSSFColor.LIME |
? |
| HSSFColor.PALE_BLUE |
? |
| HSSFColor.AQUA |
? |
| HSSFColor.GREEN |
? |
| HSSFColor.TURQUOISE |
? |
| HSSFColor.DARK_BLUE |
? |
| HSSFColor.CORNFLOWER_BLUE |
? |
| HSSFColor.OLIVE_GREEN |
? |
| HSSFColor.WHITE |
? |
| HSSFColor.LIGHT_TURQUOISE |
? |
| HSSFColor.LEMON_CHIFFON |
? |
| HSSFColor.LIGHT_GREEN |
? |
| HSSFColor.BLUE |
? |
| HSSFColor.DARK_RED |
? |
| HSSFColor.CORAL |
? |
| HSSFColor.RED |
? |
| HSSFColor.LIGHT_YELLOW |
? |
| HSSFColor.SKY_BLUE |
? |
| HSSFColor.BROWN |
? |
| HSSFColor.SEA_GREEN |
? |
| HSSFColor.INDIGO |
? |
| HSSFColor.MAROON |
? |
| HSSFColor.GREY_80_PERCENT |
? |
| HSSFColor.GREY_25_PERCENT |
? |
| HSSFColor.DARK_GREEN |
? |
| HSSFColor.YELLOW |
? |
| HSSFColor.GOLD |
? |
| HSSFColor.GREY_40_PERCENT |
? |
| HSSFColor.DARK_TEAL |
? |
| HSSFColor.PINK |
? |
| HSSFColor.ORCHID |
? |
| HSSFColor.LIGHT_BLUE |
? |
| HSSFColor.LIGHT_CORNFLOWER_BLUE |
? |
| HSSFColor.BLACK |
? |
| HSSFColor.DARK_YELLOW |
? |
| HSSFColor.VIOLET |
? |
| HSSFColor.LAVENDER |
? |
| HSSFColor.ROSE |
? |
| HSSFColor.BLUE_GREY |
? |
| HSSFColor.LIGHT_ORANGE |
? |
| HSSFColor.ORANGE |
? |
| HSSFColor.GREY_50_PERCENT |
? |
? ?
|