Syncfusion.XlsIO.Base
Example 


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

FindStringStartsWith(String,ExcelFindType) Method

Returns the first occurrence that starts with the specified string value.
Syntax
'Declaration
 
Overloads Function FindStringStartsWith( _
   ByVal findValue As String, _
   ByVal flags As ExcelFindType _
) As IRange
'Usage
 
Dim instance As IWorksheet
Dim findValue As String
Dim flags As ExcelFindType
Dim value As IRange
 
value = instance.FindStringStartsWith(findValue, flags)
IRange FindStringStartsWith( 
   string findValue,
   ExcelFindType flags
)

Parameters

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

Return Value

Returns the first occurrence that starts with the specified string value, or null if value was not found.
Example
The following code illustrates how to find the first occurrence that starts with the specified string 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 String Starts with specified string
IRange result = sheet.FindStringStartsWith("Hello", ExcelFindType.Text);
            
string fileName = "Find.xlsx";
workbook.SaveAs(fileName);
workbook.Close();
excelEngine.Dispose();
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also