GrapeCity.Documents.Excel.FindOptions

FindOptions Class

Wraps the optional parameters used by range search operations.

Use this class to configure how Find(object, IRange, FindOptions) and Find(object, IRange, FindOptions) search a range, including where to search, how to match content, the search order and direction, case sensitivity, byte matching, and an optional display format filter.

Inheritance

object

FindOptions

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public class FindOptions

Public Class FindOptions

Examples

worksheet.Range["A1"].Value = "Total";
worksheet.Range["A2"].Formula = "=A1";

FindOptions options = new FindOptions();
options.LookIn = FindLookIn.Formulas;
options.LookAt = LookAt.Part;
IRange found = worksheet.Range["A1:A2"].Find("A1", null, options);

Constructors

Name	Description
FindOptions()

Properties

Name	Description
LookAt	Gets or sets how search text is matched when this object is used with Find(object, IRange, FindOptions).
LookIn	Gets or sets the data type that the search looks in.
MatchByte	Gets or sets how double-byte characters are matched when this object is used with Find(object, IRange, FindOptions).
MatchCase	Gets or sets whether searches are case-sensitive. This property returns the current setting used by Find(object, IRange, FindOptions) and Find(object, IRange, FindOptions) to determine whether uppercase and lowercase letters are treated as different characters. The default value is `false`.
SearchDirection	Gets or sets the search direction used by Find(object, IRange, FindOptions). The returned value determines whether the search proceeds forward (Next) or backward (Previous) through the range.
SearchFormat	Gets or sets the search format. Returns the `IDisplayFormat` used to match cell formatting during a find operation. The default value is `null`.
SearchOrder	Gets or sets the order in which a range is searched when this object is used with Find(object, IRange, FindOptions).