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.
After the execution of the code, the output file looks like the below. All “search” strings within the range have been replaced with “replace”.