ValidationCollection

ValidationCollection class

Rappresenta la raccolta di convalida dei dati.

public class ValidationCollection : CollectionBase<Validation>

Proprietà

NomeDescrizione
Capacity { get; set; }
Count { get; }
Item { get; }Ottiene ilValidation elemento all’indice specificato.
Item { get; set; }

Metodi

NomeDescrizione
Add(CellArea)Aggiunge una convalida dei dati alla raccolta.
BinarySearch(Validation)
BinarySearch(Validation, IComparer<Validation>)
BinarySearch(int, int, Validation, IComparer<Validation>)
Clear()
Contains(Validation)
CopyTo(Validation[])
CopyTo(Validation[], int)
CopyTo(int, Validation[], int, int)
Exists(Predicate<Validation>)
Find(Predicate<Validation>)
FindAll(Predicate<Validation>)
FindIndex(Predicate<Validation>)
FindIndex(int, Predicate<Validation>)
FindIndex(int, int, Predicate<Validation>)
FindLast(Predicate<Validation>)
FindLastIndex(Predicate<Validation>)
FindLastIndex(int, Predicate<Validation>)
FindLastIndex(int, int, Predicate<Validation>)
GetEnumerator()
GetValidationInCell(int, int)Ottiene la convalida applicata alla cella data.
IndexOf(Validation)
IndexOf(Validation, int)
IndexOf(Validation, int, int)
LastIndexOf(Validation)
LastIndexOf(Validation, int)
LastIndexOf(Validation, int, int)
RemoveACell(int, int)Rimuove tutte le impostazioni di convalida nella cella.
RemoveArea(CellArea)Rimuove tutte le impostazioni di convalida nell’intervallo..
RemoveAt(int)

Esempi

[C#]
Workbook workbook = new Workbook();
ValidationCollection validations = workbook.Worksheets[0].Validations;
CellArea area = CellArea.CreateCellArea(0, 0, 1, 1);
Validation validation = validations[validations.Add(area)];
validation.Type = Aspose.Cells.ValidationType.List;
validation.Formula1 = "a,b,c,d";

[Visual Basic]
Dim workbook as Workbook = new Workbook()
Dim validations as ValidationCollection  = workbook.Worksheets(0).Validations
Dim area as CellArea = CellArea.CreateCellArea(0, 0, 1, 1);
Dim validation as Validation = validations(validations.Add(area))
validation.Type = ValidationType.List
validation.Formula1 = "a,b,c,d";

Guarda anche

ValidationAlertType ValidationType