GrapeCity.Documents.Excel.ReplaceOptions.SearchOrder

SearchOrder Property

SearchOrder

Gets or sets the search order.

The search order determines how a range is traversed during a replace operation. For example, ByRows searches across a row before moving to the next row, and ByColumns searches down a column before moving to the next column.

Declaration

public SearchOrder SearchOrder { get; set; }

Public Property SearchOrder As SearchOrder

Examples

worksheet.Range["A1:B2"].Value = new object[,] {
    {"NewYork", "Draft"},
    {"Review", "NewYork"}
};
ReplaceOptions options = new ReplaceOptions();
options.SearchOrder = SearchOrder.ByColumns;
SearchOrder searchOrder = options.SearchOrder;
worksheet.Range["A1:B2"].Replace("NewYork", "Seattle", options);