The background color setting in POI is as follows: Hssfcellstyle style = Workbook.createcellstyle (); Style.setfillbackgroundcolor (HSSFColor.AQUA.index ); Cell.setcellstyle (style); The color type is defined in Hssfcolor.
Color |
Execution Results |
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 |
|
The background color type of the POI operation Excel:cell