Click or drag to resize

ExcelWorksheetFind(String, ExcelFindOptions) Method

Finds the cells of the worksheet 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, row by row. The array is empty when no cell displays the text.
See Also