Find Cells with Specific Style

Sometimes, you need to find cells with a particular style applied. You can use Aspose.Cells to find all cells with a common style. Aspose.Cells provides the FindOptions.Style property which you can use to specify the style to search cells for.

The code in this example finds all cells that have the same style as that of cell A1. After the code has been executed, all the cells that have the same style as A1 contain the text “Found”.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

string filePath = dataDir+ "TestBook.xlsx";

Workbook workbook = new Workbook(filePath);

Worksheet worksheet = workbook.Worksheets[0];

// Access the style of cell A1
Style style = worksheet.Cells["A1"].GetStyle();

// Specify the style for searching
FindOptions options = new FindOptions();
options.Style = style;

Cell nextCell = null;

do
{
    // Find the cell that has a style of cell A1
    nextCell = worksheet.Cells.Find(null, nextCell, options);
    if (nextCell == null)
        break;
    // Change the text of the cell
    nextCell.PutValue("Found");

} while (true);

dataDir = dataDir + "output.out.xlsx";
workbook.Save(dataDir);