/// <summary> /// get the color value for the font /// </summary> /// <param name="wb">HSSFWorkbook</param> /// <returns></returns> public HSSFColor GetHSSFColor(HSSFWorkbook wb) { HSSFPalette pallette = wb.GetCustomPalette(); return(pallette.GetColor(Color)); }
public void SetUp() { palette = new PaletteRecord(); hssfPalette = new HSSFPalette(palette); }
private Int16 GetColorIndex(String htmlColor) { Int16 colorId = 0; try { if (htmlColor.Length > 0) { // Instantiate _customColors if required if (_customColors == null) { _customColors = new Dictionary<String, Int16>(); colorId = (Int16)((Workbook.Excel.IsOldExcel(Workbook.Excel.FileName)) ? 17 : 65); } // Get existing color index if (_customColors.ContainsKey(htmlColor)) { _customColors.TryGetValue(htmlColor, out colorId); } else { if (_customColors.Values.Count > 0) { Int16 maxId = _customColors.Values.Max(); colorId = (maxId += 1); } if (Workbook.Excel.IsOldExcel(Workbook.Excel.FileName)) { // Assign Color to OLD Excel palette if (_customPalette == null) { _customPalette = ((HSSFWorkbook)_wb).GetCustomPalette(); } Color color = ColorTranslator.FromHtml(htmlColor); _customPalette.SetColorAtIndex(colorId, (byte)color.R, (byte)color.G, (byte)color.B); } else { colorId = 0; } _customColors.Add(htmlColor, colorId); } } } catch (Exception xcp) { Logger.Log(xcp, EventLogEntryType.Error); throw new ExcelException("NPOIWorksheet GetColorIndex Exception", xcp); } return colorId; }