Click or drag to resize

IWorkbook FindAll Method

Overload List
Name Description
Public method Code example FindAll(Boolean)
This method seraches for the all cells with specified bool value.
Examples
This sample shows how to find all cells with specified bool value:
Copy 
<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cells with specified bool value</para><para>CellRange[] result = workbook.FindAllBool(true);</para>
Public method Code example FindAll(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:
Copy 
<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>
Public method Code example FindAll(TimeSpan)
This method seraches for the all cells with specified TimeSpan value.
Examples
This sample shows how to find all cells with specified TimeSpan value:
Copy 
<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>
Public method Code example FindAll(Double, FindType)
This method seraches for the all cells with specified double value.
Examples
This sample shows how to find all cells with specified doulbe value:
Copy 
<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cells with specified double value</para><para>CellRange[] result = workbook.FindAllNumber(100.32 , false);</para>
Public method Code example FindAll(String, FindType)
This method seraches for the all cells with specified string value.
Examples
This sample shows how to find all cells with specified string value:
Copy 
<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cells with specified string value</para><para>string value = "value";</para><para>CellRange[] result = workbook.FindAllString(value , false , false);</para>
Top
See Also