Spire.XLS API

IWorkbook FindAll Method (DateTime)

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

Examples

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

<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cells with specified DateTime value</para><para>CellRange[] result = workbook.FindAllDateTime(DateTime.Now);</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(
	DateTime findValue
)

Function FindAll ( 
	findValue As DateTime
) As CellRange()

array<CellRange^>^ FindAll(
	DateTime findValue
)

abstract FindAll : 
findValue : DateTime -> CellRange[]

Parameters

findValue: Type: System DateTime
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("LSTA832F0A2_0?cpp=::|nu=."); FindAll Method (DateTime)

Parameters

Return Value

Reference

IWorkbook FindAll Method (DateTime)