POI中背景颜色设置方法如下:
HSSFCellStyle style = workbook.createCellStyle(); style.setFillBackgroundColor(HSSFColor.AQUA.index); cell.setCellStyle(style);
颜色类型是在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 |
|
style = createBorderedStyle(wb);
style.setAlignment(HorizontalAlignment.RIGHT);
style.setFont(font1);
style.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
style.setDataFormat(df.getFormat("d-mmm"));
styles.put("cell_g", style);
