ExcelSetConditionalFormat Method (IExcelXml)

In This Topic

Sets the Excel XML conditional format.

Syntax

Visual Basic
C#

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

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

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

Parameters

sheet: Sheet index
firstRows: Array of first rows
lastRows: Array of last rows
firstCols: Array of first columns
lastCols: Array of last columns
comparisonOperator: Comparison operator
xf: Excel format
isFontSet: Whether the font is set
fontStyle: Font style
fontHeight: Font height
firstCondition: First condition
lastCondition: Last condition

Reference

IExcelXml Interface
IExcelXml Members

Product Support Forum | Print this page