POI操作Excel设置前景色背景色

我会带着你远行 2022-08-10 05:54 712阅读 0赞

POI中背景颜色设置方法如下:

HSSFCellStyle cellStyle = wb.createCellStyle();
    cellStyle.setFillBackgroundColor(HSSFColor.TEAL.index); //设置背景色
    cellStyle.setFillForegroundColor(HSSFColor.TEAL.index);// 设置前景色 
    cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

附：HSSFColor颜色定义

<table> 
 <tbody> 
  <tr> 
   <th>色</th> 
   <th>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 执行结果</th> 
  </tr> 
  <tr> 
   <td>HSSFColor.ROYAL_BLUE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.TEAL</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.LIME</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.PALE_BLUE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.AQUA</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.GREEN</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.TURQUOISE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.DARK_BLUE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.CORNFLOWER_BLUE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.OLIVE_GREEN</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.WHITE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.LIGHT_TURQUOISE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.LEMON_CHIFFON</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.LIGHT_GREEN</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.BLUE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.DARK_RED</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.CORAL</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.RED</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.LIGHT_YELLOW</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.SKY_BLUE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.BROWN</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.SEA_GREEN</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.INDIGO</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.MAROON</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.GREY_80_PERCENT</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.GREY_25_PERCENT</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.DARK_GREEN</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.YELLOW</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.GOLD</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.GREY_40_PERCENT</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.DARK_TEAL</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.PINK</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.ORCHID</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.LIGHT_BLUE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.LIGHT_CORNFLOWER_BLUE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.BLACK</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.DARK_YELLOW</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.VIOLET</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.LAVENDER</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.ROSE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.BLUE_GREY</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.LIGHT_ORANGE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.ORANGE</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>HSSFColor.GREY_50_PERCENT</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

作者：[itmyhome][]

[itmyhome]: http://blog.csdn.net/itmyhome1990