Spread WinForms 15
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