Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IWorksheet Interface > FindAll Method : FindAll(Double,ExcelFindType) Method
Value to search.
Type of value to search.

FindAll(Double,ExcelFindType) Method

Returns the cells of the specified double value with the specified ExcelFindType.
Syntax
'Declaration
 
Overloads Function FindAll( _
   ByVal findValue As Double, _
   ByVal flags As ExcelFindType _
) As IRange()
'Usage
 
Dim instance As IWorksheet
Dim findValue As Double
Dim flags As ExcelFindType
Dim value() As IRange
 
value = instance.FindAll(findValue, flags)

Parameters

findValue
Value to search.
flags
Type of value to search.

Return Value

All found cells, or Null if value was not found.
Example
The following code illustrates how to find the cells with specified double value.
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
IWorkbook workbook = application.Workbooks.Create(1);
IWorksheet sheet = workbook.Worksheets[0];
            
//Find All with number
IRange[] results = sheet.FindAll(100.32, ExcelFindType.Number);
            
string fileName = "Find.xlsx";
workbook.SaveAs(fileName);
workbook.Close();
excelEngine.Dispose();
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also