Spire.XLS API

IWorkbook FindOne Method (String, FindType)

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

Examples

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

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

IXLSRange FindOne(
	string findValue,
	FindType flags
)

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

IXLSRange^ FindOne(
	String^ findValue, 
	FindType flags
)

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

Parameters

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

Parameters

Return Value

Reference

IWorkbook FindOne Method (String, FindType)