ExcelGetConditionalFormats Method (IExcelBiffWrite)
Gets the conditional formats for exporting to Excel BIFF file.
'Declaration
Function ExcelGetConditionalFormats( _
ByVal As Short, _
ByRef () As Integer, _
ByRef columns() As Integer, _
ByRef () As ArrayList, _
ByRef () As ArrayList, _
ByRef () As ArrayList, _
ByRef () As ArrayList _
) As Boolean
'Usage
Dim instance As IExcelBiffWrite
Dim sheet As Short
Dim rows() As Integer
Dim columns() As Integer
Dim xfLists() As ArrayList
Dim firstConditionLists() As ArrayList
Dim lastConditionLists() As ArrayList
Dim opLists() As ArrayList
Dim value As Boolean
value = instance.ExcelGetConditionalFormats(sheet, rows, columns, xfLists, firstConditionLists, lastConditionLists, opLists)
Parameters
- sheet
- Sheet index
- rows
- Array of row indexes
- columns
- Array of column indexes
- xfLists
- Array list of Excel formats
- firstConditionLists
- Array list of first conditions
- lastConditionLists
- Array list of last conditions
- opLists
- Array list of options