How can I set the RGB Color in font Using xssfworkbook npoi

Question

How can I set the RGB color in cell backgroudn using class xssfworkbook using npoi?

byte[] rgb = new byte[3] { 192, 50, 90 };
XSSFCellStyle HeaderCellStyle1 = (XSSFCellStyle)wb.CreateCellStyle();
HeaderCellStyle1.SetFillForegroundColor(new XSSFColor(new Color(255, 255, 255)));

I don't want to use this pattern:

titlestyle.BottomBorderColor = IndexedColors.Grey25Percent.Index;

Answer 1

    solution of your problem is here

    here simply define new xssfcolor and assign it to xssfcellstyle     


 var color = new XSSFColor(new byte[] { 0,255, 0 });
 var rowstyle =(XSSFCellStyle)wb.CreateCellStyle();
 rowstyle.SetFillForegroundColor(color)