Set the foreground color background color in POI Excel

Set the foreground color background color in POI Excel

Set the background color in POI as follows:

HSSFCellStyle cellStyle = wb. createCellStyle (); cellStyle. setFillBackgroundColor (HSSFColor. TEAL. index); // set the background color cellStyle. setFillForegroundColor (HSSFColor. TEAL. index); // set the foreground color cellStyle. setFillPattern (HSSFCellStyle. SOLID_FOREGROUND );

Appendix: HSSFColor color definition

Color	Execution result
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