Click or drag to resize

ExcelWorkbookFind(String, ExcelFindOptions) Method

Finds the cells of all the worksheets that display the specified text, with the specified options. The text of a formula cell is its calculated result; call UpdateFormulaResult first to calculate the formulas added in code.

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public ExcelRange[] Find(
	string text,
	ExcelFindOptions options
)

Parameters

text  String
The text to find.
options  ExcelFindOptions
Match the case of the letters and/or the entire cell content.

Return Value

ExcelRange
The cells that display the text, worksheet by worksheet, row by row. The array is empty when no cell displays the text.
See Also