C# Class OfficeOpenXml.ConditionalFormatting.RangeConditionalFormatting

Inheritance: IRangeConditionalFormatting

Afficher le fichier Open project: ylatuya/EPPlus

Méthodes publiques

Свойство	Type	Description
_address	ExcelAddress
_worksheet	ExcelWorksheet

Méthodes publiques

Méthode	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 méthode

Add AboveOrEqualAverage Conditional Formatting

public AddAboveAverage ( ) : IExcelConditionalFormattingAverageGroup
Résultat	IExcelConditionalFormattingAverageGroup

AddAboveOrEqualAverage() public méthode

Add AboveOrEqualAverage Conditional Formatting

public AddAboveOrEqualAverage ( ) : IExcelConditionalFormattingAverageGroup
Résultat	IExcelConditionalFormattingAverageGroup

AddAboveStdDev() public méthode

Add AboveStdDev Conditional Formatting

public AddAboveStdDev ( ) : IExcelConditionalFormattingStdDevGroup
Résultat	IExcelConditionalFormattingStdDevGroup

AddBeginsWith() public méthode

Add BeginsWith Conditional Formatting

public AddBeginsWith ( ) : IExcelConditionalFormattingBeginsWith
Résultat	IExcelConditionalFormattingBeginsWith

AddBelowAverage() public méthode

Add BelowOrEqualAverage Conditional Formatting

public AddBelowAverage ( ) : IExcelConditionalFormattingAverageGroup
Résultat	IExcelConditionalFormattingAverageGroup

AddBelowOrEqualAverage() public méthode

Add BelowOrEqualAverage Conditional Formatting

public AddBelowOrEqualAverage ( ) : IExcelConditionalFormattingAverageGroup
Résultat	IExcelConditionalFormattingAverageGroup

AddBelowStdDev() public méthode

Add BelowStdDev Conditional Formatting

public AddBelowStdDev ( ) : IExcelConditionalFormattingStdDevGroup
Résultat	IExcelConditionalFormattingStdDevGroup

AddBetween() public méthode

Add Between Conditional Formatting

public AddBetween ( ) : IExcelConditionalFormattingBetween
Résultat	IExcelConditionalFormattingBetween

AddBottom() public méthode

Add Bottom Conditional Formatting

public AddBottom ( ) : IExcelConditionalFormattingTopBottomGroup
Résultat	IExcelConditionalFormattingTopBottomGroup

AddBottomPercent() public méthode

Add BottomPercent Conditional Formatting

public AddBottomPercent ( ) : IExcelConditionalFormattingTopBottomGroup
Résultat	IExcelConditionalFormattingTopBottomGroup

AddContainsBlanks() public méthode

Add ContainsBlanks Conditional Formatting

public AddContainsBlanks ( ) : IExcelConditionalFormattingContainsBlanks
Résultat	IExcelConditionalFormattingContainsBlanks

AddContainsErrors() public méthode

Add ContainsErrors Conditional Formatting

public AddContainsErrors ( ) : IExcelConditionalFormattingContainsErrors
Résultat	IExcelConditionalFormattingContainsErrors

AddContainsText() public méthode

Add ContainsText Conditional Formatting

public AddContainsText ( ) : IExcelConditionalFormattingContainsText
Résultat	IExcelConditionalFormattingContainsText

AddDuplicateValues() public méthode

Add DuplicateValues Conditional Formatting

public AddDuplicateValues ( ) : IExcelConditionalFormattingDuplicateValues
Résultat	IExcelConditionalFormattingDuplicateValues

AddEndsWith() public méthode

Add EndsWith Conditional Formatting

public AddEndsWith ( ) : IExcelConditionalFormattingEndsWith
Résultat	IExcelConditionalFormattingEndsWith

AddEqual() public méthode

Add Equal Conditional Formatting

public AddEqual ( ) : IExcelConditionalFormattingEqual
Résultat	IExcelConditionalFormattingEqual

AddExpression() public méthode

Add Expression Conditional Formatting

public AddExpression ( ) : IExcelConditionalFormattingExpression
Résultat	IExcelConditionalFormattingExpression

AddGreaterThan() public méthode

Add GreaterThan Conditional Formatting

public AddGreaterThan ( ) : IExcelConditionalFormattingGreaterThan
Résultat	IExcelConditionalFormattingGreaterThan

AddGreaterThanOrEqual() public méthode

Add GreaterThanOrEqual Conditional Formatting

public AddGreaterThanOrEqual ( ) : IExcelConditionalFormattingGreaterThanOrEqual
Résultat	IExcelConditionalFormattingGreaterThanOrEqual

AddLast7Days() public méthode

Add Last7Days Conditional Formatting

public AddLast7Days ( ) : IExcelConditionalFormattingTimePeriodGroup
Résultat	IExcelConditionalFormattingTimePeriodGroup

AddLastMonth() public méthode

Add LastMonth Conditional Formatting

public AddLastMonth ( ) : IExcelConditionalFormattingTimePeriodGroup
Résultat	IExcelConditionalFormattingTimePeriodGroup

AddLastWeek() public méthode

Add LastWeek Conditional Formatting

public AddLastWeek ( ) : IExcelConditionalFormattingTimePeriodGroup
Résultat	IExcelConditionalFormattingTimePeriodGroup

AddLessThan() public méthode

Add LessThan Conditional Formatting

public AddLessThan ( ) : IExcelConditionalFormattingLessThan
Résultat	IExcelConditionalFormattingLessThan

AddLessThanOrEqual() public méthode

Add LessThanOrEqual Conditional Formatting

public AddLessThanOrEqual ( ) : IExcelConditionalFormattingLessThanOrEqual
Résultat	IExcelConditionalFormattingLessThanOrEqual

AddNextMonth() public méthode

Add NextMonth Conditional Formatting

public AddNextMonth ( ) : IExcelConditionalFormattingTimePeriodGroup
Résultat	IExcelConditionalFormattingTimePeriodGroup

AddNextWeek() public méthode

Add NextWeek Conditional Formatting

public AddNextWeek ( ) : IExcelConditionalFormattingTimePeriodGroup
Résultat	IExcelConditionalFormattingTimePeriodGroup

AddNotBetween() public méthode

Add NotBetween Conditional Formatting

public AddNotBetween ( ) : IExcelConditionalFormattingNotBetween
Résultat	IExcelConditionalFormattingNotBetween

AddNotContainsBlanks() public méthode

Add NotContainsBlanks Conditional Formatting

public AddNotContainsBlanks ( ) : IExcelConditionalFormattingNotContainsBlanks
Résultat	IExcelConditionalFormattingNotContainsBlanks

AddNotContainsErrors() public méthode

Add NotContainsErrors Conditional Formatting

public AddNotContainsErrors ( ) : IExcelConditionalFormattingNotContainsErrors
Résultat	IExcelConditionalFormattingNotContainsErrors

AddNotContainsText() public méthode

Add NotContainsText Conditional Formatting

public AddNotContainsText ( ) : IExcelConditionalFormattingNotContainsText
Résultat	IExcelConditionalFormattingNotContainsText

AddNotEqual() public méthode

Add NotEqual Conditional Formatting

public AddNotEqual ( ) : IExcelConditionalFormattingNotEqual
Résultat	IExcelConditionalFormattingNotEqual

AddThisMonth() public méthode

Add ThisMonth Conditional Formatting

public AddThisMonth ( ) : IExcelConditionalFormattingTimePeriodGroup
Résultat	IExcelConditionalFormattingTimePeriodGroup

AddThisWeek() public méthode

Add ThisWeek Conditional Formatting

public AddThisWeek ( ) : IExcelConditionalFormattingTimePeriodGroup
Résultat	IExcelConditionalFormattingTimePeriodGroup

AddThreeColorScale() public méthode

Add ThreeColorScale Conditional Formatting

public AddThreeColorScale ( ) : IExcelConditionalFormattingThreeColorScale
Résultat	IExcelConditionalFormattingThreeColorScale

AddToday() public méthode

Add Today Conditional Formatting

public AddToday ( ) : IExcelConditionalFormattingTimePeriodGroup
Résultat	IExcelConditionalFormattingTimePeriodGroup

AddTomorrow() public méthode

Add Tomorrow Conditional Formatting

public AddTomorrow ( ) : IExcelConditionalFormattingTimePeriodGroup
Résultat	IExcelConditionalFormattingTimePeriodGroup

AddTop() public méthode

Add Top Conditional Formatting

public AddTop ( ) : IExcelConditionalFormattingTopBottomGroup
Résultat	IExcelConditionalFormattingTopBottomGroup

AddTopPercent() public méthode

Add TopPercent Conditional Formatting

public AddTopPercent ( ) : IExcelConditionalFormattingTopBottomGroup
Résultat	IExcelConditionalFormattingTopBottomGroup

AddTwoColorScale() public méthode

Add TwoColorScale Conditional Formatting

public AddTwoColorScale ( ) : IExcelConditionalFormattingTwoColorScale
Résultat	IExcelConditionalFormattingTwoColorScale

AddUniqueValues() public méthode

Add UniqueValues Conditional Formatting

public AddUniqueValues ( ) : IExcelConditionalFormattingUniqueValues
Résultat	IExcelConditionalFormattingUniqueValues

AddYesterday() public méthode

Add Yesterday Conditional Formatting

public AddYesterday ( ) : IExcelConditionalFormattingTimePeriodGroup
Résultat	IExcelConditionalFormattingTimePeriodGroup

RangeConditionalFormatting() public méthode

public RangeConditionalFormatting ( ExcelWorksheet worksheet, ExcelAddress address ) : System
worksheet	ExcelWorksheet
address	ExcelAddress
Résultat	System

Property Details

_address public_oe property

public ExcelAddress _address
Résultat	ExcelAddress

_worksheet public_oe property

public ExcelWorksheet _worksheet
Résultat	ExcelWorksheet