Class ExcelConditionalFormattingCollection

Namespace

OfficeOpenXml.ConditionalFormatting

Assembly

Magicodes.EPPlus.dll

public class ExcelConditionalFormattingCollection : XmlHelper, IEnumerable<IExcelConditionalFormattingRule>, IEnumerable

Inheritance

object

XmlHelper

ExcelConditionalFormattingCollection

Implements

IEnumerable<IExcelConditionalFormattingRule>

IEnumerable

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Properties

Count

public int Count { get; }

Property Value

int

this[int]

public IExcelConditionalFormattingRule this[int index] { get; set; }

Parameters

index int

Property Value

IExcelConditionalFormattingRule

Methods

AddAboveAverage(ExcelAddress)

public IExcelConditionalFormattingAverageGroup AddAboveAverage(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingAverageGroup

AddAboveOrEqualAverage(ExcelAddress)

public IExcelConditionalFormattingAverageGroup AddAboveOrEqualAverage(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingAverageGroup

AddAboveStdDev(ExcelAddress)

public IExcelConditionalFormattingStdDevGroup AddAboveStdDev(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingStdDevGroup

AddBeginsWith(ExcelAddress)

public IExcelConditionalFormattingBeginsWith AddBeginsWith(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingBeginsWith

AddBelowAverage(ExcelAddress)

public IExcelConditionalFormattingAverageGroup AddBelowAverage(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingAverageGroup

AddBelowOrEqualAverage(ExcelAddress)

public IExcelConditionalFormattingAverageGroup AddBelowOrEqualAverage(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingAverageGroup

AddBelowStdDev(ExcelAddress)

public IExcelConditionalFormattingStdDevGroup AddBelowStdDev(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingStdDevGroup

AddBetween(ExcelAddress)

public IExcelConditionalFormattingBetween AddBetween(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingBetween

AddBottom(ExcelAddress)

public IExcelConditionalFormattingTopBottomGroup AddBottom(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTopBottomGroup

AddBottomPercent(ExcelAddress)

public IExcelConditionalFormattingTopBottomGroup AddBottomPercent(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTopBottomGroup

AddContainsBlanks(ExcelAddress)

public IExcelConditionalFormattingContainsBlanks AddContainsBlanks(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingContainsBlanks

AddContainsErrors(ExcelAddress)

public IExcelConditionalFormattingContainsErrors AddContainsErrors(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingContainsErrors

AddContainsText(ExcelAddress)

public IExcelConditionalFormattingContainsText AddContainsText(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingContainsText

AddDatabar(ExcelAddress, Color)

public IExcelConditionalFormattingDataBarGroup AddDatabar(ExcelAddress Address, Color color)

Parameters

Address ExcelAddress

color Color

Returns

IExcelConditionalFormattingDataBarGroup

AddDuplicateValues(ExcelAddress)

public IExcelConditionalFormattingDuplicateValues AddDuplicateValues(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingDuplicateValues

AddEndsWith(ExcelAddress)

public IExcelConditionalFormattingEndsWith AddEndsWith(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingEndsWith

AddEqual(ExcelAddress)

public IExcelConditionalFormattingEqual AddEqual(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingEqual

AddExpression(ExcelAddress)

public IExcelConditionalFormattingExpression AddExpression(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingExpression

AddFiveIconSet(ExcelAddress, eExcelconditionalFormatting5IconsSetType)

public IExcelConditionalFormattingFiveIconSet AddFiveIconSet(ExcelAddress Address, eExcelconditionalFormatting5IconsSetType IconSet)

Parameters

Address ExcelAddress

IconSet eExcelconditionalFormatting5IconsSetType

Returns

IExcelConditionalFormattingFiveIconSet

AddFourIconSet(ExcelAddress, eExcelconditionalFormatting4IconsSetType)

public IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType> AddFourIconSet(ExcelAddress Address, eExcelconditionalFormatting4IconsSetType IconSet)

Parameters

Address ExcelAddress

IconSet eExcelconditionalFormatting4IconsSetType

Returns

IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType>

AddGreaterThan(ExcelAddress)

public IExcelConditionalFormattingGreaterThan AddGreaterThan(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingGreaterThan

AddGreaterThanOrEqual(ExcelAddress)

public IExcelConditionalFormattingGreaterThanOrEqual AddGreaterThanOrEqual(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingGreaterThanOrEqual

AddLast7Days(ExcelAddress)

public IExcelConditionalFormattingTimePeriodGroup AddLast7Days(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTimePeriodGroup

AddLastMonth(ExcelAddress)

public IExcelConditionalFormattingTimePeriodGroup AddLastMonth(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTimePeriodGroup

AddLastWeek(ExcelAddress)

public IExcelConditionalFormattingTimePeriodGroup AddLastWeek(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTimePeriodGroup

AddLessThan(ExcelAddress)

public IExcelConditionalFormattingLessThan AddLessThan(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingLessThan

AddLessThanOrEqual(ExcelAddress)

public IExcelConditionalFormattingLessThanOrEqual AddLessThanOrEqual(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingLessThanOrEqual

AddNextMonth(ExcelAddress)

public IExcelConditionalFormattingTimePeriodGroup AddNextMonth(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTimePeriodGroup

AddNextWeek(ExcelAddress)

public IExcelConditionalFormattingTimePeriodGroup AddNextWeek(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTimePeriodGroup

AddNotBetween(ExcelAddress)

public IExcelConditionalFormattingNotBetween AddNotBetween(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingNotBetween

AddNotContainsBlanks(ExcelAddress)

public IExcelConditionalFormattingNotContainsBlanks AddNotContainsBlanks(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingNotContainsBlanks

AddNotContainsErrors(ExcelAddress)

public IExcelConditionalFormattingNotContainsErrors AddNotContainsErrors(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingNotContainsErrors

AddNotContainsText(ExcelAddress)

public IExcelConditionalFormattingNotContainsText AddNotContainsText(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingNotContainsText

AddNotEqual(ExcelAddress)

public IExcelConditionalFormattingNotEqual AddNotEqual(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingNotEqual

AddThisMonth(ExcelAddress)

public IExcelConditionalFormattingTimePeriodGroup AddThisMonth(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTimePeriodGroup

AddThisWeek(ExcelAddress)

public IExcelConditionalFormattingTimePeriodGroup AddThisWeek(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTimePeriodGroup

AddThreeColorScale(ExcelAddress)

public IExcelConditionalFormattingThreeColorScale AddThreeColorScale(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingThreeColorScale

AddThreeIconSet(ExcelAddress, eExcelconditionalFormatting3IconsSetType)

public IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(ExcelAddress Address, eExcelconditionalFormatting3IconsSetType IconSet)

Parameters

Address ExcelAddress

IconSet eExcelconditionalFormatting3IconsSetType

Returns

IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType>

AddToday(ExcelAddress)

public IExcelConditionalFormattingTimePeriodGroup AddToday(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTimePeriodGroup

AddTomorrow(ExcelAddress)

public IExcelConditionalFormattingTimePeriodGroup AddTomorrow(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTimePeriodGroup

AddTop(ExcelAddress)

public IExcelConditionalFormattingTopBottomGroup AddTop(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTopBottomGroup

AddTopPercent(ExcelAddress)

public IExcelConditionalFormattingTopBottomGroup AddTopPercent(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTopBottomGroup

AddTwoColorScale(ExcelAddress)

public IExcelConditionalFormattingTwoColorScale AddTwoColorScale(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTwoColorScale

AddUniqueValues(ExcelAddress)

public IExcelConditionalFormattingUniqueValues AddUniqueValues(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingUniqueValues

AddYesterday(ExcelAddress)

public IExcelConditionalFormattingTimePeriodGroup AddYesterday(ExcelAddress address)

Parameters

address ExcelAddress

Returns

IExcelConditionalFormattingTimePeriodGroup

Remove(IExcelConditionalFormattingRule)

public void Remove(IExcelConditionalFormattingRule item)

Parameters

item IExcelConditionalFormattingRule

RemoveAll()

public void RemoveAll()

RemoveAt(int)

public void RemoveAt(int index)

Parameters

index int

RemoveByPriority(int)

public void RemoveByPriority(int priority)

Parameters

priority int

RulesByPriority(int)

public IExcelConditionalFormattingRule RulesByPriority(int priority)

Parameters

priority int

Returns

IExcelConditionalFormattingRule