TXlsFile.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 TExcelFile.GetDataValidation(Integer, Integer) to return the data validation in the cell.
- If you want to find out all data validation structures in the sheet, you can use TExcelFile.DataValidationCount, TExcelFile.GetDataValidationInfo and TExcelFile.GetDataValidationRanges to loop over all existing data validations.
Syntax
Unit: FlexCel.XlsAdapter
function TXlsFile.GetDataValidationRanges(const index: Integer): TArray<TXlsCellRange>; override;
Parameters
| <-> |
Parameter |
Type |
Description |
| const |
index |
Integer |
Position in the list of data validations. (1 based) |
Returns
A list of cell ranges.
See also