Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelXml Interface / ExcelSetValidationData Method
Sheet index
Validation list for the cell range
Formula


In This Topic
    ExcelSetValidationData Method (IExcelXml)
    In This Topic
    Sets the Excel XML validation data.
    Syntax
    'Declaration
     
    
    Function ExcelSetValidationData( _
       ByVal sheet As Short, _
       ByVal cellRgnList As ArrayList, _
       ByVal formula As String, _
       ByVal isEditable As Boolean _
    ) As Boolean
    'Usage
     
    
    Dim instance As IExcelXml
    Dim sheet As Short
    Dim cellRgnList As ArrayList
    Dim formula As String
    Dim isEditable As Boolean
    Dim value As Boolean
     
    value = instance.ExcelSetValidationData(sheet, cellRgnList, formula, isEditable)

    Parameters

    sheet
    Sheet index
    cellRgnList
    Validation list for the cell range
    formula
    Formula
    isEditable
    See Also