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
)
Public Function FindAll (
findValue As String,
flags As FindType,
findOptions As ExcelFindOptions
) As CellRange()
public:
array<CellRange^>^ FindAll(
String^ findValue,
FindType flags,
ExcelFindOptions findOptions
)
member FindAll :
findValue : string *
flags : FindType *
findOptions : ExcelFindOptions -> CellRange[]
Parameters
-
findValue
-
Type:
System
String
-
flags
-
Type:
Spire.Xls
FindType
-
findOptions
-
Type:
Spire.Xls
ExcelFindOptions
Return Value
Type:
CellRange
See Also