Click or drag to resize

Workbook FindTimeSpan Method

Finds the cell with the input time span.
Examples
This sample shows how to find the first cell with specified TimeSpan value:
<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cell with specified TimeSpan value</para><para>TimeSpan timeSpan = new TimeSpan(2, 30, 30);</para><para>IXLSRange result = workbook.FindTimeSpan(timeSpan);</para>

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public CellRange FindTimeSpan(
	TimeSpan timeSpanValue
)

Parameters

timeSpanValue
Type: System TimeSpan
Time span value to search for.

Return Value

Type: CellRange
Found range.
See Also