Show / Hide Table of Contents

Namespace OfficeOpenXml.ConditionalFormatting

Classes

ExcelConditionalFormattingAboveAverage

ExcelConditionalFormattingAboveAverage

ExcelConditionalFormattingAboveOrEqualAverage

ExcelConditionalFormattingAboveOrEqualAverage

ExcelConditionalFormattingAboveStdDev

ExcelConditionalFormattingAboveStdDev

ExcelConditionalFormattingAsType

Provides a simple way to type cast a conditional formatting object top its top level class.

ExcelConditionalFormattingAverageGroup

ExcelConditionalFormattingAverageGroup

ExcelConditionalFormattingBeginsWith

ExcelConditionalFormattingBeginsWith

ExcelConditionalFormattingBelowAverage

ExcelConditionalFormattingBelowAverage

ExcelConditionalFormattingBelowOrEqualAverage

ExcelConditionalFormattingBelowOrEqualAverage

ExcelConditionalFormattingBelowStdDev

ExcelConditionalFormattingBelowStdDev

ExcelConditionalFormattingBetween

ExcelConditionalFormattingBetween

ExcelConditionalFormattingBottom

ExcelConditionalFormattingBottom

ExcelConditionalFormattingBottomPercent

ExcelConditionalFormattingBottomPercent

ExcelConditionalFormattingCollection

Collection of ExcelConditionalFormattingRule. This class is providing the API for EPPlus conditional formatting.

ExcelConditionalFormattingColorScaleValue

18.3.1.11 cfvo (Conditional Format Value Object) Describes the values of the interpolation points in a gradient scale.

ExcelConditionalFormattingContainsBlanks

ExcelConditionalFormattingContainsBlanks

ExcelConditionalFormattingContainsErrors

ExcelConditionalFormattingContainsErrors

ExcelConditionalFormattingContainsText

ExcelConditionalFormattingContainsText

ExcelConditionalFormattingDataBar

Databar

ExcelConditionalFormattingDuplicateValues

ExcelConditionalFormattingDuplicateValues

ExcelConditionalFormattingEndsWith

ExcelConditionalFormattingEndsWith

ExcelConditionalFormattingEqual

ExcelConditionalFormattingEqual

ExcelConditionalFormattingExpression

ExcelConditionalFormattingExpression

ExcelConditionalFormattingFiveIconSet

Conditional formatting with a five icon set

ExcelConditionalFormattingFourIconSet

Conditional formatting with a four icon set

ExcelConditionalFormattingGreaterThan

ExcelConditionalFormattingGreaterThan

ExcelConditionalFormattingGreaterThanOrEqual

ExcelConditionalFormattingGreaterThanOrEqual

ExcelConditionalFormattingIconDataBarValue

18.3.1.11 cfvo (Conditional Format Value Object) Describes the values of the interpolation points in a gradient scale.

ExcelConditionalFormattingIconSetBase<T>

ExcelConditionalFormattingThreeIconSet

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingLastMonth

ExcelConditionalFormattingLastMonth

ExcelConditionalFormattingLastWeek

ExcelConditionalFormattingLastWeek

ExcelConditionalFormattingLessThan

ExcelConditionalFormattingLessThan

ExcelConditionalFormattingLessThanOrEqual

ExcelConditionalFormattingLessThanOrEqual

ExcelConditionalFormattingNextMonth

ExcelConditionalFormattingNextMonth

ExcelConditionalFormattingNextWeek

ExcelConditionalFormattingNextWeek

ExcelConditionalFormattingNotBetween

ExcelConditionalFormattingNotBetween

ExcelConditionalFormattingNotContainsBlanks

ExcelConditionalFormattingNotContainsBlanks

ExcelConditionalFormattingNotContainsErrors

ExcelConditionalFormattingNotContainsErrors

ExcelConditionalFormattingNotContainsText

ExcelConditionalFormattingNotContainsText

ExcelConditionalFormattingNotEqual

ExcelConditionalFormattingNotEqual

ExcelConditionalFormattingRule

ExcelConditionalFormattingThisMonth

ExcelConditionalFormattingThisMonth

ExcelConditionalFormattingThisWeek

ExcelConditionalFormattingThisWeek

ExcelConditionalFormattingThreeColorScale

ExcelConditionalFormattingThreeColorScale

ExcelConditionalFormattingThreeIconSet

Conditional formatting with a three icon set

ExcelConditionalFormattingTimePeriodGroup

ExcelConditionalFormattingTimePeriodGroup

ExcelConditionalFormattingToday

ExcelConditionalFormattingToday

ExcelConditionalFormattingTomorrow

ExcelConditionalFormattingTomorrow

ExcelConditionalFormattingTop

ExcelConditionalFormattingTop

ExcelConditionalFormattingTopPercent

ExcelConditionalFormattingTopPercent

ExcelConditionalFormattingTwoColorScale

ExcelConditionalFormattingTwoColorScale

ExcelConditionalFormattingUniqueValues

ExcelConditionalFormattingUniqueValues

ExcelConditionalFormattingYesterday

ExcelConditionalFormattingYesterday

Interfaces

IRangeConditionalFormatting

Provides functionality for adding Conditional Formatting to a range (ExcelRangeBase). Each method will return a configurable condtional formatting type.

Enums

eExcelconditionalFormatting3IconsSetType

18.18.42 ST_IconSetType (Icon Set Type) - Only 3 icons

eExcelconditionalFormatting4IconsSetType

18.18.42 ST_IconSetType (Icon Set Type) - Only 4 icons

eExcelconditionalFormatting5IconsSetType

18.18.42 ST_IconSetType (Icon Set Type) - Only 5 icons

eExcelconditionalFormattingIconsSetType

18.18.42 ST_IconSetType (Icon Set Type)

eExcelConditionalFormattingOperatorType

Enum for Conditional Formatting Operartor Type ST_ConditionalFormattingOperator §18.18.15

eExcelConditionalFormattingRuleType

Enum for Conditional Format Type ST_CfType §18.18.12. With some changes.

eExcelConditionalFormattingTimePeriodType

Enum for Conditional Formatting Time Period Type ST_TimePeriod §18.18.82

eExcelConditionalFormattingValueObjectNodeType

Enum for Conditional Formatting Value Object Node Type

eExcelConditionalFormattingValueObjectPosition

Enum for Conditional Formatting Value Object Position

eExcelConditionalFormattingValueObjectType

Enum for Conditional Format Value Object Type ST_CfvoType §18.18.13

Back to top Generated by DocFX