IXlsSearchResults

COM interface ( getting help with interfaces )

interface IXlsSearchResults : IDispatch
{

  [id(1),propget] HRESULT WorksheetCount([out, retval]long* results);
  [id(2),propget] HRESULT WorksheetItem([in]int i, [out, retval]IXlsSearchWorksheetResult** result);
  [id(3)        ] HRESULT Export([in]BSTR filename);

}

HRESULT WorksheetCount([out, retval]long* results);
returns the amount of worksheets where there is at least one match. The amount of such worksheets is less or equal than the amoutn of worksheets in the current workbook.

HRESULT WorksheetItem([in]int i, [out, retval]IXlsSearchWorksheetResult** result);
returns the ith worksheet where there is at least one match. This property is typically used in iterators with the property above. The worksheet result is the IXlsSearchWorksheetResult interface.

HRESULT Export([in]BSTR filename);
exports the results into a flat file whose full file path is passed. Uses a tabular file format. Provides a convenient mechanism to reuse the results into another application or system. For instance, this output could be imported in Excel to perform further sorting/filtering, charting etc. A typical application would either export the results into a file and then reopen that file, or use the properties above to retrieve all matches on a one-by-one basis.