C# Class OfficeOpenXml.ConditionalFormatting.RangeConditionalFormatting

Inheritance: IRangeConditionalFormatting

Datei anzeigen Open project: ylatuya/EPPlus

Public Properties

Property	Type	Description
_address	ExcelAddress
_worksheet	ExcelWorksheet

Public Methods

Method	Description
AddAboveAverage ( ) : IExcelConditionalFormattingAverageGroup	Add AboveOrEqualAverage Conditional Formatting
AddAboveOrEqualAverage ( ) : IExcelConditionalFormattingAverageGroup	Add AboveOrEqualAverage Conditional Formatting
AddAboveStdDev ( ) : IExcelConditionalFormattingStdDevGroup	Add AboveStdDev Conditional Formatting
AddBeginsWith ( ) : IExcelConditionalFormattingBeginsWith	Add BeginsWith Conditional Formatting
AddBelowAverage ( ) : IExcelConditionalFormattingAverageGroup	Add BelowOrEqualAverage Conditional Formatting
AddBelowOrEqualAverage ( ) : IExcelConditionalFormattingAverageGroup	Add BelowOrEqualAverage Conditional Formatting
AddBelowStdDev ( ) : IExcelConditionalFormattingStdDevGroup	Add BelowStdDev Conditional Formatting
AddBetween ( ) : IExcelConditionalFormattingBetween	Add Between Conditional Formatting
AddBottom ( ) : IExcelConditionalFormattingTopBottomGroup	Add Bottom Conditional Formatting
AddBottomPercent ( ) : IExcelConditionalFormattingTopBottomGroup	Add BottomPercent Conditional Formatting
AddContainsBlanks ( ) : IExcelConditionalFormattingContainsBlanks	Add ContainsBlanks Conditional Formatting
AddContainsErrors ( ) : IExcelConditionalFormattingContainsErrors	Add ContainsErrors Conditional Formatting
AddContainsText ( ) : IExcelConditionalFormattingContainsText	Add ContainsText Conditional Formatting
AddDuplicateValues ( ) : IExcelConditionalFormattingDuplicateValues	Add DuplicateValues Conditional Formatting
AddEndsWith ( ) : IExcelConditionalFormattingEndsWith	Add EndsWith Conditional Formatting
AddEqual ( ) : IExcelConditionalFormattingEqual	Add Equal Conditional Formatting
AddExpression ( ) : IExcelConditionalFormattingExpression	Add Expression Conditional Formatting
AddGreaterThan ( ) : IExcelConditionalFormattingGreaterThan	Add GreaterThan Conditional Formatting
AddGreaterThanOrEqual ( ) : IExcelConditionalFormattingGreaterThanOrEqual	Add GreaterThanOrEqual Conditional Formatting
AddLast7Days ( ) : IExcelConditionalFormattingTimePeriodGroup	Add Last7Days Conditional Formatting
AddLastMonth ( ) : IExcelConditionalFormattingTimePeriodGroup	Add LastMonth Conditional Formatting
AddLastWeek ( ) : IExcelConditionalFormattingTimePeriodGroup	Add LastWeek Conditional Formatting
AddLessThan ( ) : IExcelConditionalFormattingLessThan	Add LessThan Conditional Formatting
AddLessThanOrEqual ( ) : IExcelConditionalFormattingLessThanOrEqual	Add LessThanOrEqual Conditional Formatting
AddNextMonth ( ) : IExcelConditionalFormattingTimePeriodGroup	Add NextMonth Conditional Formatting
AddNextWeek ( ) : IExcelConditionalFormattingTimePeriodGroup	Add NextWeek Conditional Formatting
AddNotBetween ( ) : IExcelConditionalFormattingNotBetween	Add NotBetween Conditional Formatting
AddNotContainsBlanks ( ) : IExcelConditionalFormattingNotContainsBlanks	Add NotContainsBlanks Conditional Formatting
AddNotContainsErrors ( ) : IExcelConditionalFormattingNotContainsErrors	Add NotContainsErrors Conditional Formatting
AddNotContainsText ( ) : IExcelConditionalFormattingNotContainsText	Add NotContainsText Conditional Formatting
AddNotEqual ( ) : IExcelConditionalFormattingNotEqual	Add NotEqual Conditional Formatting
AddThisMonth ( ) : IExcelConditionalFormattingTimePeriodGroup	Add ThisMonth Conditional Formatting
AddThisWeek ( ) : IExcelConditionalFormattingTimePeriodGroup	Add ThisWeek Conditional Formatting
AddThreeColorScale ( ) : IExcelConditionalFormattingThreeColorScale	Add ThreeColorScale Conditional Formatting
AddToday ( ) : IExcelConditionalFormattingTimePeriodGroup	Add Today Conditional Formatting
AddTomorrow ( ) : IExcelConditionalFormattingTimePeriodGroup	Add Tomorrow Conditional Formatting
AddTop ( ) : IExcelConditionalFormattingTopBottomGroup	Add Top Conditional Formatting
AddTopPercent ( ) : IExcelConditionalFormattingTopBottomGroup	Add TopPercent Conditional Formatting
AddTwoColorScale ( ) : IExcelConditionalFormattingTwoColorScale	Add TwoColorScale Conditional Formatting
AddUniqueValues ( ) : IExcelConditionalFormattingUniqueValues	Add UniqueValues Conditional Formatting
AddYesterday ( ) : IExcelConditionalFormattingTimePeriodGroup	Add Yesterday Conditional Formatting
RangeConditionalFormatting ( ExcelWorksheet worksheet, ExcelAddress address ) : System

Method Details

AddAboveAverage() public method

Add AboveOrEqualAverage Conditional Formatting

public AddAboveAverage ( ) : IExcelConditionalFormattingAverageGroup
return	IExcelConditionalFormattingAverageGroup

AddAboveOrEqualAverage() public method

Add AboveOrEqualAverage Conditional Formatting

public AddAboveOrEqualAverage ( ) : IExcelConditionalFormattingAverageGroup
return	IExcelConditionalFormattingAverageGroup

AddAboveStdDev() public method

Add AboveStdDev Conditional Formatting

public AddAboveStdDev ( ) : IExcelConditionalFormattingStdDevGroup
return	IExcelConditionalFormattingStdDevGroup

AddBeginsWith() public method

Add BeginsWith Conditional Formatting

public AddBeginsWith ( ) : IExcelConditionalFormattingBeginsWith
return	IExcelConditionalFormattingBeginsWith

AddBelowAverage() public method

Add BelowOrEqualAverage Conditional Formatting

public AddBelowAverage ( ) : IExcelConditionalFormattingAverageGroup
return	IExcelConditionalFormattingAverageGroup

AddBelowOrEqualAverage() public method

Add BelowOrEqualAverage Conditional Formatting

public AddBelowOrEqualAverage ( ) : IExcelConditionalFormattingAverageGroup
return	IExcelConditionalFormattingAverageGroup

AddBelowStdDev() public method

Add BelowStdDev Conditional Formatting

public AddBelowStdDev ( ) : IExcelConditionalFormattingStdDevGroup
return	IExcelConditionalFormattingStdDevGroup

AddBetween() public method

Add Between Conditional Formatting

public AddBetween ( ) : IExcelConditionalFormattingBetween
return	IExcelConditionalFormattingBetween

AddBottom() public method

Add Bottom Conditional Formatting

public AddBottom ( ) : IExcelConditionalFormattingTopBottomGroup
return	IExcelConditionalFormattingTopBottomGroup

AddBottomPercent() public method

Add BottomPercent Conditional Formatting

public AddBottomPercent ( ) : IExcelConditionalFormattingTopBottomGroup
return	IExcelConditionalFormattingTopBottomGroup

AddContainsBlanks() public method

Add ContainsBlanks Conditional Formatting

public AddContainsBlanks ( ) : IExcelConditionalFormattingContainsBlanks
return	IExcelConditionalFormattingContainsBlanks

AddContainsErrors() public method

Add ContainsErrors Conditional Formatting

public AddContainsErrors ( ) : IExcelConditionalFormattingContainsErrors
return	IExcelConditionalFormattingContainsErrors

AddContainsText() public method

Add ContainsText Conditional Formatting

public AddContainsText ( ) : IExcelConditionalFormattingContainsText
return	IExcelConditionalFormattingContainsText

AddDuplicateValues() public method

Add DuplicateValues Conditional Formatting

public AddDuplicateValues ( ) : IExcelConditionalFormattingDuplicateValues
return	IExcelConditionalFormattingDuplicateValues

AddEndsWith() public method

Add EndsWith Conditional Formatting

public AddEndsWith ( ) : IExcelConditionalFormattingEndsWith
return	IExcelConditionalFormattingEndsWith

AddEqual() public method

Add Equal Conditional Formatting

public AddEqual ( ) : IExcelConditionalFormattingEqual
return	IExcelConditionalFormattingEqual

AddExpression() public method

Add Expression Conditional Formatting

public AddExpression ( ) : IExcelConditionalFormattingExpression
return	IExcelConditionalFormattingExpression

AddGreaterThan() public method

Add GreaterThan Conditional Formatting

public AddGreaterThan ( ) : IExcelConditionalFormattingGreaterThan
return	IExcelConditionalFormattingGreaterThan

AddGreaterThanOrEqual() public method

Add GreaterThanOrEqual Conditional Formatting

public AddGreaterThanOrEqual ( ) : IExcelConditionalFormattingGreaterThanOrEqual
return	IExcelConditionalFormattingGreaterThanOrEqual

AddLast7Days() public method

Add Last7Days Conditional Formatting

public AddLast7Days ( ) : IExcelConditionalFormattingTimePeriodGroup
return	IExcelConditionalFormattingTimePeriodGroup

AddLastMonth() public method

Add LastMonth Conditional Formatting

public AddLastMonth ( ) : IExcelConditionalFormattingTimePeriodGroup
return	IExcelConditionalFormattingTimePeriodGroup

AddLastWeek() public method

Add LastWeek Conditional Formatting

public AddLastWeek ( ) : IExcelConditionalFormattingTimePeriodGroup
return	IExcelConditionalFormattingTimePeriodGroup

AddLessThan() public method

Add LessThan Conditional Formatting

public AddLessThan ( ) : IExcelConditionalFormattingLessThan
return	IExcelConditionalFormattingLessThan

AddLessThanOrEqual() public method

Add LessThanOrEqual Conditional Formatting

public AddLessThanOrEqual ( ) : IExcelConditionalFormattingLessThanOrEqual
return	IExcelConditionalFormattingLessThanOrEqual

AddNextMonth() public method

Add NextMonth Conditional Formatting

public AddNextMonth ( ) : IExcelConditionalFormattingTimePeriodGroup
return	IExcelConditionalFormattingTimePeriodGroup

AddNextWeek() public method

Add NextWeek Conditional Formatting

public AddNextWeek ( ) : IExcelConditionalFormattingTimePeriodGroup
return	IExcelConditionalFormattingTimePeriodGroup

AddNotBetween() public method

Add NotBetween Conditional Formatting

public AddNotBetween ( ) : IExcelConditionalFormattingNotBetween
return	IExcelConditionalFormattingNotBetween

AddNotContainsBlanks() public method

Add NotContainsBlanks Conditional Formatting

public AddNotContainsBlanks ( ) : IExcelConditionalFormattingNotContainsBlanks
return	IExcelConditionalFormattingNotContainsBlanks

AddNotContainsErrors() public method

Add NotContainsErrors Conditional Formatting

public AddNotContainsErrors ( ) : IExcelConditionalFormattingNotContainsErrors
return	IExcelConditionalFormattingNotContainsErrors

AddNotContainsText() public method

Add NotContainsText Conditional Formatting

public AddNotContainsText ( ) : IExcelConditionalFormattingNotContainsText
return	IExcelConditionalFormattingNotContainsText

AddNotEqual() public method

Add NotEqual Conditional Formatting

public AddNotEqual ( ) : IExcelConditionalFormattingNotEqual
return	IExcelConditionalFormattingNotEqual

AddThisMonth() public method

Add ThisMonth Conditional Formatting

public AddThisMonth ( ) : IExcelConditionalFormattingTimePeriodGroup
return	IExcelConditionalFormattingTimePeriodGroup

AddThisWeek() public method

Add ThisWeek Conditional Formatting

public AddThisWeek ( ) : IExcelConditionalFormattingTimePeriodGroup
return	IExcelConditionalFormattingTimePeriodGroup

AddThreeColorScale() public method

Add ThreeColorScale Conditional Formatting

public AddThreeColorScale ( ) : IExcelConditionalFormattingThreeColorScale
return	IExcelConditionalFormattingThreeColorScale

AddToday() public method

Add Today Conditional Formatting

public AddToday ( ) : IExcelConditionalFormattingTimePeriodGroup
return	IExcelConditionalFormattingTimePeriodGroup

AddTomorrow() public method

Add Tomorrow Conditional Formatting

public AddTomorrow ( ) : IExcelConditionalFormattingTimePeriodGroup
return	IExcelConditionalFormattingTimePeriodGroup

AddTop() public method

Add Top Conditional Formatting

public AddTop ( ) : IExcelConditionalFormattingTopBottomGroup
return	IExcelConditionalFormattingTopBottomGroup

AddTopPercent() public method

Add TopPercent Conditional Formatting

public AddTopPercent ( ) : IExcelConditionalFormattingTopBottomGroup
return	IExcelConditionalFormattingTopBottomGroup

AddTwoColorScale() public method

Add TwoColorScale Conditional Formatting

public AddTwoColorScale ( ) : IExcelConditionalFormattingTwoColorScale
return	IExcelConditionalFormattingTwoColorScale

AddUniqueValues() public method

Add UniqueValues Conditional Formatting

public AddUniqueValues ( ) : IExcelConditionalFormattingUniqueValues
return	IExcelConditionalFormattingUniqueValues

AddYesterday() public method

Add Yesterday Conditional Formatting

public AddYesterday ( ) : IExcelConditionalFormattingTimePeriodGroup
return	IExcelConditionalFormattingTimePeriodGroup

RangeConditionalFormatting() public method

public RangeConditionalFormatting ( ExcelWorksheet worksheet, ExcelAddress address ) : System
worksheet	ExcelWorksheet
address	ExcelAddress
return	System

Property Details

_address public_oe property

public ExcelAddress _address
return	ExcelAddress

_worksheet public_oe property

public ExcelWorksheet _worksheet
return	ExcelWorksheet