Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IWorksheet Interface > FindStringEndsWith Method : FindStringEndsWith(String,ExcelFindType,Boolean) Method
Value to search.
Type of value to search.
True to ignore case when comparing this string to the value; otherwise, False.

FindStringEndsWith(String,ExcelFindType,Boolean) Method

Returns the first occurrence that ends with the specified string value which ignores the case.
Syntax
'Declaration
 
Overloads Function FindStringEndsWith( _
   ByVal findValue As String, _
   ByVal flags As ExcelFindType, _
   ByVal ignoreCase As Boolean _
) As IRange
'Usage
 
Dim instance As IWorksheet
Dim findValue As String
Dim flags As ExcelFindType
Dim ignoreCase As Boolean
Dim value As IRange
 
value = instance.FindStringEndsWith(findValue, flags, ignoreCase)

Parameters

findValue
Value to search.
flags
Type of value to search.
ignoreCase
True to ignore case when comparing this string to the value; otherwise, False.

Return Value

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

Syncfusion.XlsIO.Base: 16.3460.0.29

See Also