Spire.XLS API

IWorkbook FindOne Method (Double, FindType)

This method seraches for the first cell with specified double value.

Examples

This sample shows how to find the first cell with specified double value:

<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cell with specified double value</para><para>double value = 9.00;</para><para>IXLSRange result = workbook.FindNumber(value, 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

IXLSRange FindOne(
	double findValue,
	FindType flags
)

Function FindOne ( 
	findValue As Double,
	flags As FindType
) As IXLSRange

IXLSRange^ FindOne(
	double findValue, 
	FindType flags
)

abstract FindOne : 
findValue : float * 
flags : FindType -> IXLSRange

Parameters

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

Return Value

Type: IXLSRange
First found cell, or Null if value was not found.

Reference

IWorkbook Interface

FindOne Overload

Spire.Xls.Core Namespace

IWorkbook AddLanguageSpecificTextSet("LSTD884B540_0?cpp=::|nu=."); FindOne Method (Double, FindType)

Parameters

Return Value

Reference

IWorkbook FindOne Method (Double, FindType)