/// <summary>
 /// Adds a ThreeIconSet rule 
 /// </summary>
 /// <param name="IconSet"></param>
 /// <returns></returns>
 public IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(eExcelconditionalFormatting3IconsSetType IconSet)
 {
     var rule = (IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType>)(_worksheet.ConditionalFormatting.AddRule(
       eExcelConditionalFormattingRuleType.ThreeIconSet,
       _address));
     rule.IconSet = IconSet;
     return rule;
 }
Example #2
0
        /// <summary>
        /// Adds a ThreeIconSet rule
        /// </summary>
        /// <param name="IconSet"></param>
        /// <returns></returns>
        public IExcelConditionalFormattingThreeIconSet <eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(eExcelconditionalFormatting3IconsSetType IconSet)
        {
            var rule = (IExcelConditionalFormattingThreeIconSet <eExcelconditionalFormatting3IconsSetType>)(_worksheet.ConditionalFormatting.AddRule(
                                                                                                                eExcelConditionalFormattingRuleType.ThreeIconSet,
                                                                                                                _address));

            rule.IconSet = IconSet;
            return(rule);
        }
Example #3
0
        /// <summary>
        /// Add ThreeIconSet Rule
        /// </summary>
        /// <param name="Address">The address</param>
        /// <param name="IconSet">Type of iconset</param>
        /// <returns></returns>
        public IExcelConditionalFormattingThreeIconSet <eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(ExcelAddress Address, eExcelconditionalFormatting3IconsSetType IconSet)
        {
            var icon = (IExcelConditionalFormattingThreeIconSet <eExcelconditionalFormatting3IconsSetType>)AddRule(
                eExcelConditionalFormattingRuleType.ThreeIconSet,
                Address);

            icon.IconSet = IconSet;
            return(icon);
        }