Zellen mit bestimmtem Stil finden
Contents
[
Hide
]
Manchmal müssen Sie Zellen mit einem bestimmten Stil finden. Sie können Aspose.Cells for Python via .NET verwenden, um alle Zellen mit einem gemeinsamen Stil zu finden. Aspose.Cells for Python via .NET bietet die FindOptions.style-Eigenschaft, die Sie verwenden können, um den Stil für die Zellsuche festzulegen.
Der Code in diesem Beispiel sucht alle Zellen, die denselben Stil wie die Zelle A1 haben. Nachdem der Code ausgeführt wurde, enthalten alle Zellen, die denselben Stil wie A1 haben, den Text “Gefunden”.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import FindOptions, Workbook | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| filePath = "TestBook.xlsx" | |
| workbook = Workbook(filePath) | |
| worksheet = workbook.worksheets[0] | |
| # Access the style of cell A1 | |
| style = worksheet.cells.get("A1").get_style() | |
| # Specify the style for searching | |
| options = FindOptions() | |
| options.style = style | |
| nextCell = None | |
| while True: | |
| # Find the cell that has a style of cell A1 | |
| nextCell = worksheet.cells.find(None, nextCell, options) | |
| if nextCell == None: | |
| break | |
| # Change the text of the cell | |
| nextCell.put_value("Found") | |
| dataDir = "output.out.xlsx" | |
| workbook.save(dataDir) |