Jan 26, 2011 at 6:28 AM


We are trying to use NPOI.HSSF.UserModel.HSSFFont  and NPOI.HSSF.Util.HSSFColor classes to set font color. Now we are limited by the number of colors available in HSSFColor class. Is there a way to set any color say by HexCode instead of using predefined color classes?



Feb 13, 2011 at 1:12 AM

I agree with saharsh.  Why would one want to limit the color choices? My users demand certain heading row and cell colors that are not available. 

Great project.  I wish I knew how to write something like this.


Sep 5, 2013 at 9:20 PM
Edited Sep 5, 2013 at 10:10 PM
Slowpokes attacking! It was really hard find solution for XSSFColor, but I got it (think HSSFColor should be same):
style.FillForegroundXSSFColor.SetRgb(new byte[] { Color.LightPink.R, Color.LightPink.G, Color.LightPink.B });