GrapeCity.Documents.Excel.LookAt

LookAt Enum

Specifies whether a search matches against the whole cell content or any part of it.

Used with LookAt and LookAt to control the matching behavior of Find(object, IRange, FindOptions) and Replace(object, object, ReplaceOptions).

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum LookAt

Public Enum LookAt

Examples

worksheet.Range["A1"].Value = "Hello World";
worksheet.Range["A2"].Value = "Hello";

FindOptions options = new FindOptions();
options.LookAt = LookAt.Whole;
IRange found = worksheet.Range["A1:A2"].Find("Hello", null, options);
// found refers to A2, because only "Hello" matches the whole cell content

Fields

Name	Description
Part	Matches any part of the cell content.
Whole	Matches the whole cell content.