TExcelFile.GetDataValidationInfo Method
Returns the data validation information for an entry of the index. 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 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 DataValidationCount, GetDataValidationInfo and GetDataValidationRanges to loop over all existing data validations.
Syntax
Unit: FlexCel.Core
function TExcelFile.GetDataValidationInfo(const index: Integer): TDataValidationInfo; virtual; abstract;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | index | Integer | Position in the list of data validations. (1 based) |
Returns
Data validation information.