Interface IRangeConditionalFormatting

Namespace

OfficeOpenXml.ConditionalFormatting

Assembly

Magicodes.EPPlus.dll

public interface IRangeConditionalFormatting

Extension Methods

ExtensionMethods.IsNumeric(object)

Methods

AddAboveAverage()

IExcelConditionalFormattingAverageGroup AddAboveAverage()

Returns

IExcelConditionalFormattingAverageGroup

AddAboveOrEqualAverage()

IExcelConditionalFormattingAverageGroup AddAboveOrEqualAverage()

Returns

IExcelConditionalFormattingAverageGroup

AddAboveStdDev()

IExcelConditionalFormattingStdDevGroup AddAboveStdDev()

Returns

IExcelConditionalFormattingStdDevGroup

AddBeginsWith()

IExcelConditionalFormattingBeginsWith AddBeginsWith()

Returns

IExcelConditionalFormattingBeginsWith

AddBelowAverage()

IExcelConditionalFormattingAverageGroup AddBelowAverage()

Returns

IExcelConditionalFormattingAverageGroup

AddBelowOrEqualAverage()

IExcelConditionalFormattingAverageGroup AddBelowOrEqualAverage()

Returns

IExcelConditionalFormattingAverageGroup

AddBelowStdDev()

IExcelConditionalFormattingStdDevGroup AddBelowStdDev()

Returns

IExcelConditionalFormattingStdDevGroup

AddBetween()

IExcelConditionalFormattingBetween AddBetween()

Returns

IExcelConditionalFormattingBetween

AddBottom()

IExcelConditionalFormattingTopBottomGroup AddBottom()

Returns

IExcelConditionalFormattingTopBottomGroup

AddBottomPercent()

IExcelConditionalFormattingTopBottomGroup AddBottomPercent()

Returns

IExcelConditionalFormattingTopBottomGroup

AddContainsBlanks()

IExcelConditionalFormattingContainsBlanks AddContainsBlanks()

Returns

IExcelConditionalFormattingContainsBlanks

AddContainsErrors()

IExcelConditionalFormattingContainsErrors AddContainsErrors()

Returns

IExcelConditionalFormattingContainsErrors

AddContainsText()

IExcelConditionalFormattingContainsText AddContainsText()

Returns

IExcelConditionalFormattingContainsText

AddDatabar(Color)

IExcelConditionalFormattingDataBarGroup AddDatabar(Color color)

Parameters

color Color

Returns

IExcelConditionalFormattingDataBarGroup

AddDuplicateValues()

IExcelConditionalFormattingDuplicateValues AddDuplicateValues()

Returns

IExcelConditionalFormattingDuplicateValues

AddEndsWith()

IExcelConditionalFormattingEndsWith AddEndsWith()

Returns

IExcelConditionalFormattingEndsWith

AddEqual()

IExcelConditionalFormattingEqual AddEqual()

Returns

IExcelConditionalFormattingEqual

AddExpression()

IExcelConditionalFormattingExpression AddExpression()

Returns

IExcelConditionalFormattingExpression

AddFiveIconSet(eExcelconditionalFormatting5IconsSetType)

IExcelConditionalFormattingFiveIconSet AddFiveIconSet(eExcelconditionalFormatting5IconsSetType IconSet)

Parameters

IconSet eExcelconditionalFormatting5IconsSetType

Returns

IExcelConditionalFormattingFiveIconSet

AddFourIconSet(eExcelconditionalFormatting4IconsSetType)

IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType> AddFourIconSet(eExcelconditionalFormatting4IconsSetType IconSet)

Parameters

IconSet eExcelconditionalFormatting4IconsSetType

Returns

IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType>

AddGreaterThan()

IExcelConditionalFormattingGreaterThan AddGreaterThan()

Returns

IExcelConditionalFormattingGreaterThan

AddGreaterThanOrEqual()

IExcelConditionalFormattingGreaterThanOrEqual AddGreaterThanOrEqual()

Returns

IExcelConditionalFormattingGreaterThanOrEqual

AddLast7Days()

IExcelConditionalFormattingTimePeriodGroup AddLast7Days()

Returns

IExcelConditionalFormattingTimePeriodGroup

AddLastMonth()

IExcelConditionalFormattingTimePeriodGroup AddLastMonth()

Returns

IExcelConditionalFormattingTimePeriodGroup

AddLastWeek()

IExcelConditionalFormattingTimePeriodGroup AddLastWeek()

Returns

IExcelConditionalFormattingTimePeriodGroup

AddLessThan()

IExcelConditionalFormattingLessThan AddLessThan()

Returns

IExcelConditionalFormattingLessThan

AddLessThanOrEqual()

IExcelConditionalFormattingLessThanOrEqual AddLessThanOrEqual()

Returns

IExcelConditionalFormattingLessThanOrEqual

AddNextMonth()

IExcelConditionalFormattingTimePeriodGroup AddNextMonth()

Returns

IExcelConditionalFormattingTimePeriodGroup

AddNextWeek()

IExcelConditionalFormattingTimePeriodGroup AddNextWeek()

Returns

IExcelConditionalFormattingTimePeriodGroup

AddNotBetween()

IExcelConditionalFormattingNotBetween AddNotBetween()

Returns

IExcelConditionalFormattingNotBetween

AddNotContainsBlanks()

IExcelConditionalFormattingNotContainsBlanks AddNotContainsBlanks()

Returns

IExcelConditionalFormattingNotContainsBlanks

AddNotContainsErrors()

IExcelConditionalFormattingNotContainsErrors AddNotContainsErrors()

Returns

IExcelConditionalFormattingNotContainsErrors

AddNotContainsText()

IExcelConditionalFormattingNotContainsText AddNotContainsText()

Returns

IExcelConditionalFormattingNotContainsText

AddNotEqual()

IExcelConditionalFormattingNotEqual AddNotEqual()

Returns

IExcelConditionalFormattingNotEqual

AddThisMonth()

IExcelConditionalFormattingTimePeriodGroup AddThisMonth()

Returns

IExcelConditionalFormattingTimePeriodGroup

AddThisWeek()

IExcelConditionalFormattingTimePeriodGroup AddThisWeek()

Returns

IExcelConditionalFormattingTimePeriodGroup

AddThreeColorScale()

IExcelConditionalFormattingThreeColorScale AddThreeColorScale()

Returns

IExcelConditionalFormattingThreeColorScale

AddThreeIconSet(eExcelconditionalFormatting3IconsSetType)

IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(eExcelconditionalFormatting3IconsSetType IconSet)

Parameters

IconSet eExcelconditionalFormatting3IconsSetType

Returns

IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType>

AddToday()

IExcelConditionalFormattingTimePeriodGroup AddToday()

Returns

IExcelConditionalFormattingTimePeriodGroup

AddTomorrow()

IExcelConditionalFormattingTimePeriodGroup AddTomorrow()

Returns

IExcelConditionalFormattingTimePeriodGroup

AddTop()

IExcelConditionalFormattingTopBottomGroup AddTop()

Returns

IExcelConditionalFormattingTopBottomGroup

AddTopPercent()

IExcelConditionalFormattingTopBottomGroup AddTopPercent()

Returns

IExcelConditionalFormattingTopBottomGroup

AddTwoColorScale()

IExcelConditionalFormattingTwoColorScale AddTwoColorScale()

Returns

IExcelConditionalFormattingTwoColorScale

AddUniqueValues()

IExcelConditionalFormattingUniqueValues AddUniqueValues()

Returns

IExcelConditionalFormattingUniqueValues

AddYesterday()

IExcelConditionalFormattingTimePeriodGroup AddYesterday()

Returns

IExcelConditionalFormattingTimePeriodGroup