Syncfusion.XlsIO.Base
Example 


Value to search.

FindFirst(DateTime) Method

Returns the first occurrence of the specified DateTime value.
Syntax
'Declaration
 
Overloads Function FindFirst( _
   ByVal findValue As Date _
) As IRange
'Usage
 
Dim instance As IWorksheet
Dim findValue As Date
Dim value As IRange
 
value = instance.FindFirst(findValue)
IRange FindFirst( 
   DateTime findValue
)

Parameters

findValue
Value to search.

Return Value

Returns the first cell with a specified DateTime value, or null if value was not found.
Example
The following code illustrates how to find the first occurrence of the specified DateTime 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 First with DateTime
IRange result = sheet.FindFirst(DateTime.Now);
            
string fileName = "Find.xlsx";
workbook.SaveAs(fileName);
workbook.Close();
excelEngine.Dispose();
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also