GrapeCity.Documents.Excel.SearchDirection

SearchDirection Enum

Specifies the direction to search within a range when using the Find(object, IRange, FindOptions) method.

Used with SearchDirection to control whether the search proceeds forward (Next) or backward (Previous) through the range.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum SearchDirection

Public Enum SearchDirection

Examples

worksheet.Range["A1:A3"].Value = new object[,] {{10}, {20}, {10}};
IRange searchRange = worksheet.Range["A1:A3"];

FindOptions options = new FindOptions();
options.SearchDirection = SearchDirection.Previous;
IRange found = searchRange.Find(10, null, options);

Fields

Name	Description
Next	Search for next matching value in range.
Previous	Search for previous matching value in range.