Click or drag to resize

IWorkbook FindOne Method

Overload List
Name Description
Public method Code example FindOne(Boolean)
This method seraches for the first cell with specified bool value.
Examples
This sample shows how to find the first cell with specified bool value:
Copy 
<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cell with specified bool value</para><para>IXLSRange result = workbook.FindBool(true);</para>
Public method Code example FindOne(DateTime)
This method seraches for the first cell with specified DateTime value.
Examples
This sample shows how to find the first cell with specified DateTime value:
Copy 
<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cell with specified DateTime value</para><para>DateTime dateTime = DateTime.Now;</para><para>IXLSRange result = workbook.FindDateTime(dateTime);</para>
Public method Code example FindOne(TimeSpan)
This method seraches for the first cell with specified TimeSpan value.
Examples
This sample shows how to find the first cell with specified TimeSpan value:
Copy 
<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>
Public method Code example FindOne(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:
Copy 
<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>
Public method Code example FindOne(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:
Copy 
<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>
Top
See Also