C# Класс OfficeOpenXml.ConditionalFormatting.RangeConditionalFormatting

Наследование: IRangeConditionalFormatting

Открытые свойства

Свойство	Тип	Описание
_address	ExcelAddress
_worksheet	ExcelWorksheet

Открытые методы

Метод	Описание
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

Описание методов

AddAboveAverage() публичный Метод

Add AboveOrEqualAverage Conditional Formatting

public AddAboveAverage ( ) : IExcelConditionalFormattingAverageGroup
Результат	IExcelConditionalFormattingAverageGroup

AddAboveOrEqualAverage() публичный Метод

Add AboveOrEqualAverage Conditional Formatting

public AddAboveOrEqualAverage ( ) : IExcelConditionalFormattingAverageGroup
Результат	IExcelConditionalFormattingAverageGroup

AddAboveStdDev() публичный Метод

Add AboveStdDev Conditional Formatting

public AddAboveStdDev ( ) : IExcelConditionalFormattingStdDevGroup
Результат	IExcelConditionalFormattingStdDevGroup

AddBeginsWith() публичный Метод

Add BeginsWith Conditional Formatting

public AddBeginsWith ( ) : IExcelConditionalFormattingBeginsWith
Результат	IExcelConditionalFormattingBeginsWith

AddBelowAverage() публичный Метод

Add BelowOrEqualAverage Conditional Formatting

public AddBelowAverage ( ) : IExcelConditionalFormattingAverageGroup
Результат	IExcelConditionalFormattingAverageGroup

AddBelowOrEqualAverage() публичный Метод

Add BelowOrEqualAverage Conditional Formatting

public AddBelowOrEqualAverage ( ) : IExcelConditionalFormattingAverageGroup
Результат	IExcelConditionalFormattingAverageGroup

AddBelowStdDev() публичный Метод

Add BelowStdDev Conditional Formatting

public AddBelowStdDev ( ) : IExcelConditionalFormattingStdDevGroup
Результат	IExcelConditionalFormattingStdDevGroup

AddBetween() публичный Метод

Add Between Conditional Formatting

public AddBetween ( ) : IExcelConditionalFormattingBetween
Результат	IExcelConditionalFormattingBetween

AddBottom() публичный Метод

Add Bottom Conditional Formatting

public AddBottom ( ) : IExcelConditionalFormattingTopBottomGroup
Результат	IExcelConditionalFormattingTopBottomGroup

AddBottomPercent() публичный Метод

Add BottomPercent Conditional Formatting

public AddBottomPercent ( ) : IExcelConditionalFormattingTopBottomGroup
Результат	IExcelConditionalFormattingTopBottomGroup

AddContainsBlanks() публичный Метод

Add ContainsBlanks Conditional Formatting

public AddContainsBlanks ( ) : IExcelConditionalFormattingContainsBlanks
Результат	IExcelConditionalFormattingContainsBlanks

AddContainsErrors() публичный Метод

Add ContainsErrors Conditional Formatting

public AddContainsErrors ( ) : IExcelConditionalFormattingContainsErrors
Результат	IExcelConditionalFormattingContainsErrors

AddContainsText() публичный Метод

Add ContainsText Conditional Formatting

public AddContainsText ( ) : IExcelConditionalFormattingContainsText
Результат	IExcelConditionalFormattingContainsText

AddDuplicateValues() публичный Метод

Add DuplicateValues Conditional Formatting

public AddDuplicateValues ( ) : IExcelConditionalFormattingDuplicateValues
Результат	IExcelConditionalFormattingDuplicateValues

AddEndsWith() публичный Метод

Add EndsWith Conditional Formatting

public AddEndsWith ( ) : IExcelConditionalFormattingEndsWith
Результат	IExcelConditionalFormattingEndsWith

AddEqual() публичный Метод

Add Equal Conditional Formatting

public AddEqual ( ) : IExcelConditionalFormattingEqual
Результат	IExcelConditionalFormattingEqual

AddExpression() публичный Метод

Add Expression Conditional Formatting

public AddExpression ( ) : IExcelConditionalFormattingExpression
Результат	IExcelConditionalFormattingExpression

AddGreaterThan() публичный Метод

Add GreaterThan Conditional Formatting

public AddGreaterThan ( ) : IExcelConditionalFormattingGreaterThan
Результат	IExcelConditionalFormattingGreaterThan

AddGreaterThanOrEqual() публичный Метод

Add GreaterThanOrEqual Conditional Formatting

public AddGreaterThanOrEqual ( ) : IExcelConditionalFormattingGreaterThanOrEqual
Результат	IExcelConditionalFormattingGreaterThanOrEqual

AddLast7Days() публичный Метод

Add Last7Days Conditional Formatting

public AddLast7Days ( ) : IExcelConditionalFormattingTimePeriodGroup
Результат	IExcelConditionalFormattingTimePeriodGroup

AddLastMonth() публичный Метод

Add LastMonth Conditional Formatting

public AddLastMonth ( ) : IExcelConditionalFormattingTimePeriodGroup
Результат	IExcelConditionalFormattingTimePeriodGroup

AddLastWeek() публичный Метод

Add LastWeek Conditional Formatting

public AddLastWeek ( ) : IExcelConditionalFormattingTimePeriodGroup
Результат	IExcelConditionalFormattingTimePeriodGroup

AddLessThan() публичный Метод

Add LessThan Conditional Formatting

public AddLessThan ( ) : IExcelConditionalFormattingLessThan
Результат	IExcelConditionalFormattingLessThan

AddLessThanOrEqual() публичный Метод

Add LessThanOrEqual Conditional Formatting

public AddLessThanOrEqual ( ) : IExcelConditionalFormattingLessThanOrEqual
Результат	IExcelConditionalFormattingLessThanOrEqual

AddNextMonth() публичный Метод

Add NextMonth Conditional Formatting

public AddNextMonth ( ) : IExcelConditionalFormattingTimePeriodGroup
Результат	IExcelConditionalFormattingTimePeriodGroup

AddNextWeek() публичный Метод

Add NextWeek Conditional Formatting

public AddNextWeek ( ) : IExcelConditionalFormattingTimePeriodGroup
Результат	IExcelConditionalFormattingTimePeriodGroup

AddNotBetween() публичный Метод

Add NotBetween Conditional Formatting

public AddNotBetween ( ) : IExcelConditionalFormattingNotBetween
Результат	IExcelConditionalFormattingNotBetween

AddNotContainsBlanks() публичный Метод

Add NotContainsBlanks Conditional Formatting

public AddNotContainsBlanks ( ) : IExcelConditionalFormattingNotContainsBlanks
Результат	IExcelConditionalFormattingNotContainsBlanks

AddNotContainsErrors() публичный Метод

Add NotContainsErrors Conditional Formatting

public AddNotContainsErrors ( ) : IExcelConditionalFormattingNotContainsErrors
Результат	IExcelConditionalFormattingNotContainsErrors

AddNotContainsText() публичный Метод

Add NotContainsText Conditional Formatting

public AddNotContainsText ( ) : IExcelConditionalFormattingNotContainsText
Результат	IExcelConditionalFormattingNotContainsText

AddNotEqual() публичный Метод

Add NotEqual Conditional Formatting

public AddNotEqual ( ) : IExcelConditionalFormattingNotEqual
Результат	IExcelConditionalFormattingNotEqual

AddThisMonth() публичный Метод

Add ThisMonth Conditional Formatting

public AddThisMonth ( ) : IExcelConditionalFormattingTimePeriodGroup
Результат	IExcelConditionalFormattingTimePeriodGroup

AddThisWeek() публичный Метод

Add ThisWeek Conditional Formatting

public AddThisWeek ( ) : IExcelConditionalFormattingTimePeriodGroup
Результат	IExcelConditionalFormattingTimePeriodGroup

AddThreeColorScale() публичный Метод

Add ThreeColorScale Conditional Formatting

public AddThreeColorScale ( ) : IExcelConditionalFormattingThreeColorScale
Результат	IExcelConditionalFormattingThreeColorScale

AddToday() публичный Метод

Add Today Conditional Formatting

public AddToday ( ) : IExcelConditionalFormattingTimePeriodGroup
Результат	IExcelConditionalFormattingTimePeriodGroup

AddTomorrow() публичный Метод

Add Tomorrow Conditional Formatting

public AddTomorrow ( ) : IExcelConditionalFormattingTimePeriodGroup
Результат	IExcelConditionalFormattingTimePeriodGroup

AddTop() публичный Метод

Add Top Conditional Formatting

public AddTop ( ) : IExcelConditionalFormattingTopBottomGroup
Результат	IExcelConditionalFormattingTopBottomGroup

AddTopPercent() публичный Метод

Add TopPercent Conditional Formatting

public AddTopPercent ( ) : IExcelConditionalFormattingTopBottomGroup
Результат	IExcelConditionalFormattingTopBottomGroup

AddTwoColorScale() публичный Метод

Add TwoColorScale Conditional Formatting

public AddTwoColorScale ( ) : IExcelConditionalFormattingTwoColorScale
Результат	IExcelConditionalFormattingTwoColorScale

AddUniqueValues() публичный Метод

Add UniqueValues Conditional Formatting

public AddUniqueValues ( ) : IExcelConditionalFormattingUniqueValues
Результат	IExcelConditionalFormattingUniqueValues

AddYesterday() публичный Метод

Add Yesterday Conditional Formatting

public AddYesterday ( ) : IExcelConditionalFormattingTimePeriodGroup
Результат	IExcelConditionalFormattingTimePeriodGroup

RangeConditionalFormatting() публичный Метод

public RangeConditionalFormatting ( ExcelWorksheet worksheet, ExcelAddress address ) : System
worksheet	ExcelWorksheet
address	ExcelAddress
Результат	System

Описание свойств

_address публичное свойство

public ExcelAddress _address
Результат	ExcelAddress

_worksheet публичное свойство

public ExcelWorksheet _worksheet
Результат	ExcelWorksheet