GrapeCity.Documents.Excel.SearchOrder

SearchOrder Enum

Specifies the order in which to search a range.

Use this enum with search-related APIs to control whether the search progresses row by row or column by column.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum SearchOrder

Public Enum SearchOrder

Examples

worksheet.Range["A1:C3"].Value = new object[,] {
    {"Name", "Score", "City"},
    {"Alice", 100, "Paris"},
    {"Bob", 100, "Tokyo"}
};
FindOptions options = new FindOptions();
options.SearchOrder = SearchOrder.ByColumns;
IRange found = worksheet.Range["A1:C3"].Find(100, null, options);

Fields

Name	Description
ByColumns	Searches down through a column, then moves to the next column.
ByRows	Searches across a row, then moves to the next row.