ExcelSetConditionalFormat Method (IExcelBiffRead)

In This Topic

CONDFMT, CF - Excel Biff Records

Syntax

Visual Basic
C#

'Declaration
 
Function ExcelSetConditionalFormat( _
   ByVal sheet As Short, _
   ByVal firstRows() As Integer, _
   ByVal lastRows() As Integer, _
   ByVal firstCols() As Integer, _
   ByVal lastCols() As Integer, _
   ByVal comparisonOperator As Byte, _
   ByVal xf As IExcelXF, _
   ByVal isFontSet As Boolean, _
   ByVal fontStyle As FontStyle, _
   ByVal fontHeight As Integer, _
   ByVal patternStyle As Integer, _
   ByVal firstCondition() As Byte, _
   ByVal lastCondition() As Byte _
) As Boolean

'Usage
 
Dim instance As IExcelBiffRead
Dim sheet As Short
Dim firstRows() As Integer
Dim lastRows() As Integer
Dim firstCols() As Integer
Dim lastCols() As Integer
Dim comparisonOperator As Byte
Dim xf As IExcelXF
Dim isFontSet As Boolean
Dim fontStyle As FontStyle
Dim fontHeight As Integer
Dim patternStyle As Integer
Dim firstCondition() As Byte
Dim lastCondition() As Byte
Dim value As Boolean
 
value = instance.ExcelSetConditionalFormat(sheet, firstRows, lastRows, firstCols, lastCols, comparisonOperator, xf, isFontSet, fontStyle, fontHeight, patternStyle, firstCondition, lastCondition)

bool ExcelSetConditionalFormat( 
   short sheet,
   int[] firstRows,
   int[] lastRows,
   int[] firstCols,
   int[] lastCols,
   byte comparisonOperator,
   IExcelXF xf,
   bool isFontSet,
   FontStyle fontStyle,
   int fontHeight,
   int patternStyle,
   byte[] firstCondition,
   byte[] lastCondition
)

Parameters

sheet: Sheet index
firstRows
lastRows
firstCols
lastCols
comparisonOperator
xf
isFontSet
fontStyle
fontHeight
patternStyle
firstCondition
lastCondition

Reference

IExcelBiffRead Interface
IExcelBiffRead Members

Product Support Forum | Print this page