Spire.XLS API

IWorkbook FindAll Method (Double, FindType)

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

Examples

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

<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cells with specified double value</para><para>CellRange[] result = workbook.FindAllNumber(100.32 , 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(
	double findValue,
	FindType flags
)

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

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

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

Parameters

findValue: Type: System Double
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("LSTCD64128E_0?cpp=::|nu=."); FindAll Method (Double, FindType)

Parameters

Return Value

Reference

IWorkbook FindAll Method (Double, FindType)