Search and Replace Data in a Range

Aspose.Cells provides the FindOptions.setRange() method for specifying a range when searching for data.

Suppose you want to search for the string “search” and replace it with “replace” in the range E3:H6. In the screenshot below, the string “search” can be seen in several cells but we want to replace it only in a given range, here highlighted in yellow.

Input file


After the execution of the code, the output file looks like the below. All “search” strings within the range have been replaced with “replace”.

Output file