介绍NPOI 的颜色卡、名称以及索引

前言

使用NPOI的颜色时，一些颜色类的名称很难想象出具体对应的颜色，所以有了下面的对照表，方便使用。

NPOI 颜色的索引范围是 8~64,超出范围无效。

遍历NPOI颜色

使用调色板HSSFPalette 检验自动生成的颜色是否在NPOI中有定义。

void ExcelColor(){//创建工作簿对象HSSFWorkbook workBook = new HSSFWorkbook();//创建一个sheetISheet sheet = workBook.CreateSheet("ColorTable");IRow row ;ICell cell;//调色板HSSFPalette palette = workBook.GetCustomPalette();List<Color> colorList = new List<Color>();Random random = new Random(Guid.NewGuid().GetHashCode());for(int i=0; i<random.Next(100,200); i++){colorList.Add(Color.FromArgb(random.Next(0, 255),random.Next(0, 255),random.Next(0, 255)));}short FIRST_COLOR_INDEX = (short)0x8;for (int i = 0; i < colorList.Count; i++){if ((short)(FIRST_COLOR_INDEX + i) > (short)0x40){break;}//index的取值范围0x8-0x40palette.SetColorAtIndex((short)(FIRST_COLOR_INDEX + i),colorList[i].R, colorList[i].G, colorList[i].B);}int StartColIndex = 0;int rowIndex = 0;int colIndex = StartColIndex;for (int i = 0; i < colorList.Count; i++){if (i > (short)(0x40 - 0x8)){break;}var vl = palette.FindColor(colorList[i].R, colorList[i].G, colorList[i].B);if (vl == null){// throw new Exception("Color is Valid");continue;}row = sheet.CreateRow(rowIndex);cell = row.CreateCell(0);ICellStyle cellStyle = workBook.CreateCellStyle();cellStyle.FillPattern = FillPattern.SolidForeground;cellStyle.FillForegroundColor = vl.GetIndex();cell.CellStyle = cellStyle;cell = row.CreateCell(1);cell.SetCellValue(vl.GetHexString());cell = row.CreateCell(2);cell.SetCellValue(vl.GetIndex());rowIndex++;}string fileName = @"testColor.xls";using (FileStream file = new FileStream(fileName, FileMode.Create)){workBook.Write(file);file.Close();}}

效果图：