Search and Replace Data in a Range

Sometimes you need to search for and replace specific data in a range, ignoring any cell values outside the desired range. Aspose.Cells allows you to limit a search to a specific range. This article explains how.

Aspose.Cells provides the FindOptions.SetRange() method for specifying a range when searching data. The code sample below searches and replaces data in a range.