GrapeCity.Documents.Excel.FindOptions.SearchOrder

SearchOrder Property

SearchOrder

Gets or sets the order in which a range is searched when this object is used with Find(object, IRange, FindOptions).

Declaration

public SearchOrder SearchOrder { get; set; }

Public Property SearchOrder As SearchOrder

Examples

worksheet.Range["A1:B2"].Value = new object[,] {
    {"Name", "Value"},
    {"Test", "Value"}
};
FindOptions options = new FindOptions();
options.SearchOrder = SearchOrder.ByColumns;
SearchOrder searchOrder = options.SearchOrder;
worksheet.Range["A1:B2"].Find("Value", null, options);