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.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic ExcelRange[] Find(
string text,
ExcelFindOptions options
)
Public Function Find (
text As String,
options As ExcelFindOptions
) As ExcelRange()
Parameters
- text String
- The text to find.
- options ExcelFindOptions
- Match the case of the letters and/or the entire cell content.
Return Value
ExcelRangeThe cells that display the text, worksheet by worksheet, row by row. The array is empty when no cell displays the text.
See Also