XlsFile.GetDataValidationRanges Method
Returns a list of ranges for which a data validation definition applies. There are 2 ways you can access the data validation information on a sheet:
- If you know the row and column where you want to look, you can use ExcelFile.GetDataValidation(Int32, Int32) to return the data validation in the cell.
- If you want to find out all data validation structures in the sheet, you can use ExcelFile.DataValidationCount, ExcelFile.GetDataValidationInfo and ExcelFile.GetDataValidationRanges to loop over all existing data validations.
Syntax
Namespace: FlexCel.XlsAdapter
public override TXlsCellRange[] GetDataValidationRanges(Int32 index)Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| index | Int32 | Position in the list of data validations. (1 based) |
Returns
A list of cell ranges.