NPOI 设置条件格式

本文链接： https://blog.csdn.net/lishuangquan1987/article/details/102725977

var workbook = new HSSFWorkbook();
var worksheet = workbook.CreateSheet();
var conditionFormatting = worksheet.SheetConditionalFormatting;
var rule = conditionFormatting.CreateConditionalFormattingRule(
     NPOI.SS.UserModel.ComparisonOperator.Between,
     "10",
     "100"
    );
var patternFormat = rule.CreatePatternFormatting();
patternFormat.FillBackgroundColor = NPOI.HSSF.Util.HSSFColor.Red.Index;
var regions = new CellRangeAddress[] {new CellRangeAddress (0, 10, 0, 10) };
conditionFormatting.AddConditionalFormatting(regions,rule);
FileStream fs = new FileStream("test.xls", FileMode.Create, FileAccess.Write);
workbook.Write(fs);
fs.Close();
Console.Read();