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.
- GetEnumerator
- GetFormula
- GetType
- GetStringValue
- GetIntValue
- GetBoolValue
- GetDateTimeValue
- GetDoubleValue
- GetFloatValue
View more methods.
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 formula =SUM(A5:A10): C6
Name of the cell containing the formula that contains CHA: C7
Name of the cell containing the number 80: A8
Name of the cell containing specified string: C8
Name of the cell containing the string that contains Two: C9
Name of the cell containing specified string: C10
Name of the cell containing specified string: C11