Exemplos de eExcelconditionalFormatting5IconsSetType em C# (CSharp)

Exemplo n.º 1

        /// <summary>
        /// Adds a FiveIconSet rule
        /// </summary>
        /// <param name="IconSet"></param>
        /// <returns></returns>
        public IExcelConditionalFormattingFiveIconSet AddFiveIconSet(eExcelconditionalFormatting5IconsSetType IconSet)
        {
            var rule = (IExcelConditionalFormattingFiveIconSet)(_worksheet.ConditionalFormatting.AddRule(
                                                                    eExcelConditionalFormattingRuleType.FiveIconSet,
                                                                    _address));

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

Exemplo n.º 2

Arquivo: RangeConditionalFormatting.cs Projeto: Eagle-Chan/KIS

 /// <summary>
 /// Adds a FiveIconSet rule 
 /// </summary>
 /// <param name="IconSet"></param>
 /// <returns></returns>
 public IExcelConditionalFormattingFiveIconSet AddFiveIconSet(eExcelconditionalFormatting5IconsSetType IconSet)
 {
     var rule = (IExcelConditionalFormattingFiveIconSet)(_worksheet.ConditionalFormatting.AddRule(
       eExcelConditionalFormattingRuleType.FiveIconSet,
       _address));
     rule.IconSet = IconSet;
     return rule;
 }

Exemplo n.º 3

        /// <summary>
        /// Adds a FiveIconSet rule
        /// </summary>
        /// <param name="Address"></param>
        /// <param name="IconSet"></param>
        /// <returns></returns>
        public IExcelConditionalFormattingFiveIconSet AddFiveIconSet(ExcelAddress Address, eExcelconditionalFormatting5IconsSetType IconSet)
        {
            var icon = (IExcelConditionalFormattingFiveIconSet)AddRule(
                eExcelConditionalFormattingRuleType.FiveIconSet,
                Address);

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