XlsFile.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:

1. 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.
2. 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 TDataValidationInfo GetDataValidationInfo(Int32 index)

Parameters

<->	Parameter	Type	Description
	index	Int32	Position in the list of data validations. (1 based)

Returns

Data validation information.

See also

• XlsFile