Find or Search Data
Contents
[
Hide
]
Find or Search Data
You can use Aspose.Cells to find or search data in various ways using the following method. These methods find the data as per their names.
- FindNumber
- FindFormula
- FindFormulaContains
- FindString
- FindStringContains
- FindStringStartsWith
- FindStringEndsWith
The following sample code illustrates the usage of the above methods using the sample excel file as shown in this screenshot.
Sample Code
Console Output
This is the console output of the above sample code when executed with the given sample excel file.
Name of the cell containing the number 80: A8
Name of the cell containing formula =SUM(A5:A10): C6
Name of the cell containing the formula that contains CHA: C7
Name of the cell containing specified string: C8
Name of the cell containing the string that contains Two: C9
Name of the cell containing the string that starts with AAA: C10
Name of the cell containing the string that ends with BBB: C11