Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelXml Interface / ExcelGetConditionalFormatsXML Method
Sheet index
Row indexes
Column indexes
Cross-reference lists
Lists of first conditions
Lists of last conditions
Options lists


In This Topic
    ExcelGetConditionalFormatsXML Method
    In This Topic
    Get the Excel XML conditional format.
    Syntax
    'Declaration
     
    
    Function ExcelGetConditionalFormatsXML( _
       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 IExcelXml
    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.ExcelGetConditionalFormatsXML(sheet, rows, columns, xfLists, firstConditionLists, lastConditionLists, opLists)
    bool ExcelGetConditionalFormatsXML( 
       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
    Row indexes
    columns
    Column indexes
    xfLists
    Cross-reference lists
    firstConditionLists
    Lists of first conditions
    lastConditionLists
    Lists of last conditions
    opLists
    Options lists
    See Also