Click or drag to resize

XlsWorksheetsCollection FindAll Method (String, FindType, ExcelFindOptions)

Finds all occurrences of a specified value within the worksheet and returns their ranges.

Namespace: Spire.Xls.Core.Spreadsheet.Collections
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public CellRange[] FindAll(
	string findValue,
	FindType flags,
	ExcelFindOptions findOptions
)

Parameters

findValue
Type: System String
flags
Type: Spire.Xls FindType
findOptions
Type: Spire.Xls ExcelFindOptions

Return Value

Type: CellRange
See Also