CXllFinder::CXllFinder

Constructs a CXllFinder object

CXllFinder(
   const char* pszFind,
   BOOL bLookInFormulae = FALSE,
   BOOL bMatchWhole = FALSE,
   DWORD dwSheetId = 0
);
CXllFinder(
   const char* pszFind,
   BOOL bLookInFormulae,
   BOOL bMatchWhole,
   const CString& strBook,
   const CString& strSheet
);

Parameters

pszFind

A null-terminated string that contains the text being searched for.

bLookInFormulae

If TRUE, then cell formulae will be searched; if FALSE, then cell values will be searched.

bMatchWhole

If TRUE, then only cells whose entire contents match the search string will be found; if FALSE then all cells that contain the search string will be matched.

dwSheetId

The ID of the sheet to be searched. This can be extracted from references, using CXlOper::GetSheetId(), or derived from a call to CXllApp::GetSheetId().

If the value is 0, then the current sheet will be searched.

strBook

The name of the workbook containing the sheet to be searched.

strSheet

The name of the sheet to be searched.

Remarks

Constructs a CXllFinder object, which can then be used to iterate through all the matching cells within a sheet.

Requirements

Header: xllfinder.h

See Also

CXllFinder Class | CXllFinder Methods