Wiki Markup |
---|
{description} {excerpt}Creates a [DataValidation] object which can be set on a [Range], [Area], or [Cell].{excerpt} {signature:C#} public DataValidation CreateDataValidation(ValidationType allowedType, System.String formula) {signature}{signature:vb.net} Public Function CreateDataValidation(ByVal allowedType As ValidationType, ByVal formula As String) As DataValidation {signature} {parameters} {param:allowedType}The data type allowed in the cell.{param} {param:formula}For 'Custom' allowed type: the formula used to validate the cell's data. For 'List' allowed type: the formula referencing a range in the worksheet.{param} {returns}A [DataValidation|DataValidation] object.{returns} {example}{code:csharp|title=C#} DataValidation dataValidation = wb.createDataValidation( DataValidation.ValidationType.List, "C10:C18"); {code} {code:vb.net|title=vb.net} Dim dataValidation As DataValidation = _ wb.createDataValidation( _ DataValidation.ValidationType.List, _ "C10:C18") {code} {example} |
Page History
Overview
Content Tools