转：POI操作Excel:cell的背景颜色类型

来源：互联网发布：linux 更改权限编辑：程序博客网时间：2024/05/21 21:39

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

0 0