Table of Contents

TXlsFile.DataValidationCount Property

Returns the number of DataValidation structures in the active sheet. 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 TExcelFile.GetDataValidation(Integer, Integer) 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 TExcelFile.DataValidationCount, TExcelFile.GetDataValidationInfo and TExcelFile.GetDataValidationRanges to loop over all existing data validations.

Syntax

Unit: FlexCel.XlsAdapter

property TXlsFile.DataValidationCount: Integer

See also