npoi单元格颜色对照表

本文记录使用NPOI操作Excel时,设置单元格背景色的值。

ICellStyle style = workbook.CreateCellStyle();
style.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.Red.Index;
style.FillPattern = FillPattern.SolidForeground;
 
ICell cell = workbook.CreateSheet().CreateRow(0).CreateCell(0);
cell.CellStyle = style;
颜色 Class名称
  Black
  Brown
  Olive_Green
  Dark_Green
  Dark_Teal
  Dark_Blue
  Indigo
  Grey_80_PERCENT
  Dark_Red
  Orange
  DARK_YELLOW
  Green
  Teal
  Blue
  Blue_Grey
  Grey_50_PERCENT
  Red
  LIGHT_ORANGE
  LIME
  SEA_GREEN
  AQUA
  LIGHT_BLUE
  VIOLET
  GREY_40_PERCENT
  Pink
  Gold
  Yellow
  BRIGHT_GREEN
  TURQUOISE
  SKY_BLUE
  Plum
  GREY_25_PERCENT
  Rose
  Tan
  LIGHT_YELLOW
  LIGHT_GREEN
  LIGHT_TURQUOISE
  PALE_BLUE
  LAVENDER
  White
  CORNFLOWER_BLUE
  LEMON_CHIFFON
  MAROON
  ORCHID
  CORAL
  ROYAL_BLUE
  LIGHT_CORNFLOWER_BLUE
  AUTOMATIC

如果觉得我的文章对您有用,请随意打赏。

您的支持将是我最大的动力!