Spire.XLS API

XlsWorksheetsCollection FindFirst Method (String, FindType, ExcelFindOptions)

Finds the first occurrence of a specified value within the range based on the given find type and options.

Namespace: Spire.Xls.Core.Spreadsheet.Collections
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

public IXLSRange FindFirst(
	string findValue,
	FindType flags,
	ExcelFindOptions findOptions
)

Public Function FindFirst ( 
	findValue As String,
	flags As FindType,
	findOptions As ExcelFindOptions
) As IXLSRange

public:
IXLSRange^ FindFirst(
	String^ findValue, 
	FindType flags, 
	ExcelFindOptions findOptions
)

member FindFirst : 
findValue : string * 
flags : FindType * 
findOptions : ExcelFindOptions -> IXLSRange

findValue: Type: System String
The value to search for.
flags: Type: Spire.Xls FindType
The type of value to find, such as text, formula, formula string value, or error.
findOptions: Type: Spire.Xls ExcelFindOptions
Additional options for the find operation.

Type: IXLSRange
The first range that matches the search criteria, or null if no match is found.

Exceptions

Exception	Condition
ArgumentException	Thrown when the provided find type flags are not valid.

XlsWorksheetsCollection AddLanguageSpecificTextSet("LSTEDB01B0B_0?cpp=::|nu=."); FindFirst Method (String, FindType, ExcelFindOptions)