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