Spire.XLS API

IWorkbook FindAll Method (String, FindType)

This method seraches for the all cells with specified string value.

Examples

This sample shows how to find all cells with specified string value:

<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cells with specified string value</para><para>string value = "value";</para><para>CellRange[] result = workbook.FindAllString(value , false , false);</para>

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

Syntax

C++

ASP.NET

Copy

CellRange[] FindAll(
	string findValue,
	FindType flags
)

Function FindAll ( 
	findValue As String,
	flags As FindType
) As CellRange()

array<CellRange^>^ FindAll(
	String^ findValue, 
	FindType flags
)

abstract FindAll : 
findValue : string * 
flags : FindType -> CellRange[]

Parameters

findValue: Type: System String
Value to search.
flags: Type: Spire.Xls FindType
Type of value to search.

Return Value

Type: CellRange
All found cells, or Null if value was not found.

Reference

IWorkbook Interface

FindAll Overload

Spire.Xls.Core Namespace

IWorkbook AddLanguageSpecificTextSet("LST29BDF777_0?cpp=::|nu=."); FindAll Method (String, FindType)

Parameters

Return Value

Reference

IWorkbook FindAll Method (String, FindType)