Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
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 methods.
- 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 the 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 a specified string: C8
Name of the cell containing the string that contains "Two": C9
Name of the cell containing a specified string: C10
Name of the cell containing a specified string: C11