/// <summary> /// 获取条件格式规则 /// </summary> /// <param name="cell">单元格</param> public static NPOI.SS.UserModel.IConditionalFormattingRule[] GetConditionalFormattingRules(this NPOI.SS.UserModel.ICell cell) { var cfrs = new List <NPOI.SS.UserModel.IConditionalFormattingRule>(); var scf = cell.Sheet.SheetConditionalFormatting; for (var i = 0; i < scf.NumConditionalFormattings; i++) { var cf = scf.GetConditionalFormattingAt(i); if (cell.ExistConditionalFormatting(cf)) { for (var j = 0; j < cf.NumberOfRules; j++) { cfrs.Add(cf.GetRule(j)); } } } return(cfrs.ToArray()); }