Excel.SearchCriteria interface

Represents the search criteria to be used.

Remarks

[ API set: ExcelApi 1.9 ]

Properties

completeMatch

Specifies if the match needs to be complete or partial. A complete match matches the entire contents of the cell. A partial match matches a substring within the content of the cell (e.g., cat partially matches caterpillar and scatter). Default is false (partial).

matchCase

Specifies if the match is case-sensitive. Default is false (case-insensitive).

searchDirection

Specifies the search direction. Default is forward. See Excel.SearchDirection.

Property Details

completeMatch

Specifies if the match needs to be complete or partial. A complete match matches the entire contents of the cell. A partial match matches a substring within the content of the cell (e.g., cat partially matches caterpillar and scatter). Default is false (partial).

completeMatch?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

matchCase

Specifies if the match is case-sensitive. Default is false (case-insensitive).

matchCase?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

searchDirection

Specifies the search direction. Default is forward. See Excel.SearchDirection.

searchDirection?: Excel.SearchDirection | "Forward" | "Backwards";

Property Value

Excel.SearchDirection | "Forward" | "Backwards"

Remarks

[ API set: ExcelApi 1.9 ]