Class ExcelConditionalFormattingCollection
Inheritance
System.Object
ExcelConditionalFormattingCollection
Implements
System.Collections.IEnumerable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Assembly: EPPlus.dll
public class ExcelConditionalFormattingCollection : XmlHelper, IEnumerable<IExcelConditionalFormattingRule>, IEnumerable
Properties
Declaration
public int Count { get; }
Property Value
Type |
Description |
System.Int32 |
|
Index operator, returns by 0-based index
Declaration
public IExcelConditionalFormattingRule this[int index] { get; set; }
Parameters
Type |
Name |
Description |
System.Int32 |
index |
|
Property Value
Methods
Declaration
public IExcelConditionalFormattingAverageGroup AddAboveAverage(ExcelAddress address)
Parameters
Returns
Add AboveOrEqualAverage Rule
Declaration
public IExcelConditionalFormattingAverageGroup AddAboveOrEqualAverage(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingStdDevGroup AddAboveStdDev(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingBeginsWith AddBeginsWith(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingAverageGroup AddBelowAverage(ExcelAddress address)
Parameters
Returns
Add BelowOrEqualAverage Rule
Declaration
public IExcelConditionalFormattingAverageGroup AddBelowOrEqualAverage(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingStdDevGroup AddBelowStdDev(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingBetween AddBetween(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTopBottomGroup AddBottom(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTopBottomGroup AddBottomPercent(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingContainsBlanks AddContainsBlanks(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingContainsErrors AddContainsErrors(ExcelAddress address)
Parameters
Returns
AddContainsText(ExcelAddress)
Declaration
public IExcelConditionalFormattingContainsText AddContainsText(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingDataBarGroup AddDatabar(ExcelAddress Address, Color color)
Parameters
Type |
Name |
Description |
ExcelAddress |
Address |
|
System.Drawing.Color |
color |
|
Returns
Declaration
public IExcelConditionalFormattingDuplicateValues AddDuplicateValues(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingEndsWith AddEndsWith(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingEqual AddEqual(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingExpression AddExpression(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingFiveIconSet AddFiveIconSet(ExcelAddress Address, eExcelconditionalFormatting5IconsSetType IconSet)
Parameters
Returns
Declaration
public IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType> AddFourIconSet(ExcelAddress Address, eExcelconditionalFormatting4IconsSetType IconSet)
Parameters
Returns
Declaration
public IExcelConditionalFormattingGreaterThan AddGreaterThan(ExcelAddress address)
Parameters
Returns
Add GreaterThanOrEqual Rule
Declaration
public IExcelConditionalFormattingGreaterThanOrEqual AddGreaterThanOrEqual(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTimePeriodGroup AddLast7Days(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTimePeriodGroup AddLastMonth(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTimePeriodGroup AddLastWeek(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingLessThan AddLessThan(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingLessThanOrEqual AddLessThanOrEqual(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTimePeriodGroup AddNextMonth(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTimePeriodGroup AddNextWeek(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingNotBetween AddNotBetween(ExcelAddress address)
Parameters
Returns
Add NotContainsBlanks Rule
Declaration
public IExcelConditionalFormattingNotContainsBlanks AddNotContainsBlanks(ExcelAddress address)
Parameters
Returns
Add NotContainsErrors Rule
Declaration
public IExcelConditionalFormattingNotContainsErrors AddNotContainsErrors(ExcelAddress address)
Parameters
Returns
AddNotContainsText(ExcelAddress)
Declaration
public IExcelConditionalFormattingNotContainsText AddNotContainsText(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingNotEqual AddNotEqual(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTimePeriodGroup AddThisMonth(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTimePeriodGroup AddThisWeek(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingThreeColorScale AddThreeColorScale(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(ExcelAddress Address, eExcelconditionalFormatting3IconsSetType IconSet)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTimePeriodGroup AddToday(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTimePeriodGroup AddTomorrow(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTopBottomGroup AddTop(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTopBottomGroup AddTopPercent(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTwoColorScale AddTwoColorScale(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingUniqueValues AddUniqueValues(ExcelAddress address)
Parameters
Returns
Declaration
public IExcelConditionalFormattingTimePeriodGroup AddYesterday(ExcelAddress address)
Parameters
Returns
Remove a Conditional Formatting Rule by its object
Declaration
public void Remove(IExcelConditionalFormattingRule item)
Parameters
Removes all 'cfRule' from the collection and from the XML.
This is the same as removing all the 'conditionalFormatting' nodes.
Declaration
Remove a Conditional Formatting Rule by its 0-based index
Declaration
public void RemoveAt(int index)
Parameters
Type |
Name |
Description |
System.Int32 |
index |
|
Remove a Conditional Formatting Rule by its priority
Declaration
public void RemoveByPriority(int priority)
Parameters
Type |
Name |
Description |
System.Int32 |
priority |
|
Get a rule by its priority
Declaration
public IExcelConditionalFormattingRule RulesByPriority(int priority)
Parameters
Type |
Name |
Description |
System.Int32 |
priority |
|
Returns
Explicit Interface Implementations
Get the 'cfRule' enumerator
Declaration
IEnumerator<IExcelConditionalFormattingRule> IEnumerable<IExcelConditionalFormattingRule>.GetEnumerator()
Returns
Get the 'cfRule' enumerator
Declaration
IEnumerator IEnumerable.GetEnumerator()
Returns
Type |
Description |
System.Collections.IEnumerator |
|
Implements
System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable