ExcelGetConditionalFormats Method (IExcelBiffWrite)

In This Topic

Gets the conditional formats for exporting to Excel BIFF file.

Syntax

Visual Basic
C#

'Declaration
 
Function ExcelGetConditionalFormats( _
   ByVal sheet As Short, _
   ByRef rows() As Integer, _
   ByRef columns() As Integer, _
   ByRef xfLists() As ArrayList, _
   ByRef firstConditionLists() As ArrayList, _
   ByRef lastConditionLists() As ArrayList, _
   ByRef opLists() 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)

bool ExcelGetConditionalFormats( 
   short sheet,
   ref int[] rows,
   ref int[] columns,
   ref ArrayList[] xfLists,
   ref ArrayList[] firstConditionLists,
   ref ArrayList[] lastConditionLists,
   ref ArrayList[] 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

Reference

IExcelBiffWrite Interface
IExcelBiffWrite Members

Product Support Forum | Print this page