DataValidationCollection
Overview
DataValidationCollection is a class in Aspose.Cells FOSS for Typescript.
DataValidationCollection.add() creates a new DataValidation object that can be configured and added to a worksheet.
This class provides 5 methods for working with DataValidationCollection objects in Typescript programs.
Available methods include: add, clear, get, remove, toXml.
All public members are accessible to any Typescript application after installing the Aspose.Cells FOSS for Typescript package.
Properties: count.
Description
DataValidationCollection is a class in the Aspose.Cells FOSS library for TypeScript that exposes 5 methods and 1 property for programmatic use.
Core capabilities include: number; removes the data validation at the specified index; removes all data validations from the collection. These operations enable developers to integrate datavalidationcollection functionality directly into TypeScript applications.
The class also provides the count property (gets the count).
Properties
| Name | Type | Access | Description |
|---|---|---|---|
count | number | Read | Gets the count. |
Methods
| Signature | Description |
|---|---|
add() → DataValidation | Creates a new DataValidation instance and adds it to the collection for the worksheet |
get(index: number) → DataValidation | undefined | Returns the data validation at the given index, or undefined if not found. |
remove(index: number) | Removes the data validation at the specified index. |
clear() | Removes all data validations from the collection. |
toXml() → string | Serializes the data validation collection to an XML string. |