Click or drag to resize

Workbook FindAllTimeSpan Method

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

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

Parameters

timeSpanValue
Type: System TimeSpan

Return Value

Type: CellRange
Found ranges.
See Also