NPOI 1.2.3教程 -20 填充背景FillBackground

最新推荐文章于 2023-07-06 21:15:00 发布

原创

最新推荐文章于 2023-07-06 21:15:00 发布 · 6.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#stream #file #string #class

本文档详细介绍了如何使用NPOI库为Excel工作表的单元格填充不同背景色，包括多种填充样式，如大点、小点、砖块等，并展示了如何设置工作表标签的颜色。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System; using System.Text; using System.IO; using NPOI.HSSF.UserModel; using NPOI.HPSF; using NPOI.POIFS.FileSystem; using NPOI.SS.UserModel; namespace FillBackgroundInXls { class Program { static void Main(string[] args) { InitializeWorkbook(); Sheet sheet1 = hssfworkbook.CreateSheet("Sheet1"); //fill background CellStyle style1 = hssfworkbook.CreateCellStyle(); style1.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.BLUE.index; style1.FillPattern = FillPatternType.BIG_SPOTS; style1.FillBackgroundColor = NPOI.HSSF.Util.HSSFColor.PINK.index; sheet1.CreateRow(0).CreateCell(0).CellStyle = style1; //fill background CellStyle style2 = hssfworkbook.CreateCellStyle(); style2.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.YELLOW.index; style2.FillPattern = FillPatternType.ALT_BARS; style2.FillBackgroundColor = NPOI.HSSF.Util.HSSFColor.ROSE.index; sheet1.CreateRow(1).CreateCell(0).CellStyle = style2; //fill background CellStyle style3 = hssfworkbook.CreateCellStyle(); style3.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.LIME.index; style3.FillPattern = FillPatternType.LESS_DOTS; style3.FillBackgroundColor = NPOI.HSSF.Util.HSSFColor.LIGHT_GREEN.index; sheet1.CreateRow(2).CreateCell(0).CellStyle = style3; //fill background CellStyle style4 = hssfworkbook.CreateCellStyle(); style4.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.YELLOW.index; style4.FillPattern = FillPatternType.LEAST_DOTS; style4.FillBackgroundColor = NPOI.HSSF.Util.HSSFColor.ROSE.index; sheet1.CreateRow(3).CreateCell(0).CellStyle = style4; //fill background