TExcelFile.GetDataValidation Method

Overloads

TExcelFile.GetDataValidation(Integer, Integer)

Returns the validation information for an specific cell. If the cell has no Data Validation associated, this method returns null.

Syntax

Unit: FlexCel.Core

function TExcelFile.GetDataValidation(const row: Integer; const col: Integer): TDataValidationInfo; overload;

Parameters

<-> Parameter Type Description
const row Integer Row of the cell (1 based)
const col Integer Column of the cell (1 based)

Returns

The data validation for a cell, or null if the cell has no Data Validation associated.

See also

TExcelFile.GetDataValidation(Integer, Integer, TXlsCellRange)

Returns the validation information for an specific cell. If the cell has no Data Validation associated, this method returns null.

Syntax

Unit: FlexCel.Core

function TExcelFile.GetDataValidation(const row: Integer; const col: Integer; out dvRange: TXlsCellRange): TDataValidationInfo; overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const row Integer Row of the cell (1 based)
const col Integer Column of the cell (1 based)
out dvRange TXlsCellRange Range of cells where the data validation is applied.

Returns

The data validation for a cell, or null if the cell has no Data Validation associated.

See also