GrapeCity.Documents.Excel.ReplaceOptions.LookAt

LookAt Property

LookAt

Gets or sets how the search text is matched during a replace operation.

Declaration

public LookAt LookAt { get; set; }

Public Property LookAt As LookAt

Examples

worksheet.Range["A1:A3"].Value = new object[,] {
    {"NewYork"},
    {"York"},
    {"NewYork City"}
};
ReplaceOptions options = new ReplaceOptions();
options.LookAt = LookAt.Whole;
LookAt lookAt = options.LookAt;
worksheet.Range["A1:A3"].Replace("NewYork", "Seattle", options);