IXlsSearchOptions

COM interface ( getting help with interfaces )

interface IXlsSearchOptions : IDispatch
{

  [id(1),propput] HRESULT CaseSensitive([in]BOOL casesensitive);
  [id(1),propget] HRESULT CaseSensitive([out, retval]BOOL* casesensitive);
  [id(2),propput] HRESULT RemoveDuplicates([in]BOOL removeduplicates);
  [id(2),propget] HRESULT RemoveDuplicates([out, retval]BOOL* removeduplicates);
  [id(3),propput] HRESULT UsesWildcards([in]BOOL useswildcards);
  [id(3),propget] HRESULT UsesWildcards([out, retval]BOOL* useswildcards);

}

HRESULT CaseSensitive([in]BOOL casesensitive);
sets whether the search is case sensitive. Default value is not. When case sensitiveness is applied, "Hello" and "hello" don't match.

HRESULT RemoveDuplicates([in]BOOL removeduplicates);
sets whether, when more than matches are found in a single Excel worksheet, they should be kept or not. Default value is YES. This option is an efficient way to filter out results without having to make custom development.

HRESULT UsesWildcards([in]BOOL useswildcards);
sets whether the keyword uses one ore more * characters that act as wildcards like in Windows Explorer. Default value is NO. Wildcards can be used to replace a group of unknown characters and is an efficient mechanism to filter out results based on what you are looking for. To escape * characters when you are using wildcards, in order to have them act as regular * characters, use \. For instance, in "\*hell*" only the second star character acts as a wildcard. The escaping makes no sense if the wildcards are not activated.