Find or Search Data

Find or Search Data

You can use Aspose.Cells to find or search data in various ways using the following method.

View more methods.

The following sample code illustrates the usage of the above methods using the sample excel file as shown in this screenshot.

todo:image_alt_text

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