/// <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());
}