ExcelSetConditionalFormat Method (IExcelXml)
Sets the Excel XML conditional format.
bool ExcelSetConditionalFormat(
short ,
ArrayList ,
ArrayList ,
ArrayList ,
ArrayList ,
byte ,
IExcelXF ,
bool ,
FontStyle ,
int ,
string ,
string
)
'Declaration
Function ExcelSetConditionalFormat( _
ByVal As Short, _
ByVal As ArrayList, _
ByVal As ArrayList, _
ByVal As ArrayList, _
ByVal As ArrayList, _
ByVal As Byte, _
ByVal As IExcelXF, _
ByVal As Boolean, _
ByVal As FontStyle, _
ByVal As Integer, _
ByVal As String, _
ByVal 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)
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