Belirli Stile Sahip Hücreleri Bul

Contents
[ ]

Bu örnek kod, A1 hücresiyle aynı stile sahip tüm hücreleri bulur. Kod çalıştırıldıktan sonra, A1 ile aynı stile sahip tüm hücreler “Bulundu” metnini içerir.

// 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);