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