Table of Contents

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

  1. If you know the row and column where you want to look, you can use 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 DataValidationCount, GetDataValidationInfo and GetDataValidationRanges to loop over all existing data validations.

Syntax

Namespace: FlexCel.Core

public abstract TXlsCellRange[] GetDataValidationRanges(Int32 index)

Parameters

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

Returns

A list of cell ranges.

See also