C# 클래스 OfficeOpenXml.ConditionalFormatting.RangeConditionalFormatting

상속: IRangeConditionalFormatting
파일 보기 프로젝트 열기: ylatuya/EPPlus

공개 프로퍼티들

프로퍼티 타입 설명
_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