NPOI 设置单元格字体颜色以及背景颜色

爱你雨中泪

于 2024-10-23 19:43:38 发布

阅读量769

点赞数 1

文章标签： c#

本文链接：https://blog.youkuaiyun.com/u014316488/article/details/143192186

版权

 ICellStyle style = row.Sheet.Workbook.CreateCellStyle();
 //style.FillForegroundColor = NPOI.SS.UserModel.IndexedColors.Red.Index;
 //style.FillPattern = FillPattern.SolidForeground;
 style.FillForegroundColor = 0;
 style.FillPattern = FillPattern.SolidForeground;
 ((XSSFColor)style.FillForegroundColorColor).SetRgb(new byte[] { 0, 176, 240 });

 byte[] rgb = new byte[3];
 rgb[0] = (byte)242; // red
 rgb[1] = (byte)10; // green
 rgb[2] = (byte)10; // blue
 XSSFColor myColor = new XSSFColor(rgb);  
 var font = (XSSFFont)row.Sheet.Workbook.CreateFont();
 font.IsBold =  true;
 font.SetColor(myColor);
 font.FontName = "Arial";
 font.FontHeightInPoints = 10;
 style.SetFont(font);
row.Cells[4].CellStyle = style;