Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelBiffWrite Interface / ExcelGetValidationData Method
The sheet.
The collection of validation data.
The collection of row for cell validation data.
The collection of column for cell validation data.
An indicator of whether each cell validation combo is editable.


In This Topic
    ExcelGetValidationData Method
    In This Topic
    Gets validation data from specified sheet.
    Syntax
    'Declaration
     
    
    Sub ExcelGetValidationData( _
       ByVal sheet As Integer, _
       ByVal m_dvStringArr As ArrayList, _
       ByVal m_dvRowArr As ArrayList, _
       ByVal m_dvColumnArr As ArrayList, _
       ByVal m_dvIsEditable As ArrayList _
    ) 
    'Usage
     
    
    Dim instance As IExcelBiffWrite
    Dim sheet As Integer
    Dim m_dvStringArr As ArrayList
    Dim m_dvRowArr As ArrayList
    Dim m_dvColumnArr As ArrayList
    Dim m_dvIsEditable As ArrayList
     
    instance.ExcelGetValidationData(sheet, m_dvStringArr, m_dvRowArr, m_dvColumnArr, m_dvIsEditable)

    Parameters

    sheet
    The sheet.
    m_dvStringArr
    The collection of validation data.
    m_dvRowArr
    The collection of row for cell validation data.
    m_dvColumnArr
    The collection of column for cell validation data.
    m_dvIsEditable
    An indicator of whether each cell validation combo is editable.
    See Also