This project is read-only.

HSSFColor

Jan 26, 2011 at 6:28 AM

Hello,

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?

 

Thanks,
Saharsh

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.

Thanks

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 });