Comment contrôler la vue du classeur
Contents
[
Hide
]
Scénarios d’utilisation possibles
Lorsque vous avez besoin d’ajuster l’affichage des pages Excel, vous devez savoir comment contrôler chaque module, comme les barres de défilement horizontales et verticales, masquer ou non les fichiers Excel ouverts, etc. Aspose.Cells offre cette fonctionnalité. Aspose.Cells fournit les propriétés et méthodes suivantes pour vous aider à atteindre vos objectifs.
- WorkbookSettings.is_h_scroll_bar_visible
- WorkbookSettings.is_v_scroll_bar_visible
- WorkbookSettings.is_hidden
- WorkbookSettings.is_minimized
- WorkbookSettings.window_height
- WorkbookSettings.window_width
- WorkbookSettings.window_left
- WorkbookSettings.window_top
Comment contrôler la vue du classeur à l’aide de Aspose.Cells for .NET
Cet exemple montre comment :
- Créer un classeur.
- Ajouter des données aux cellules dans la première feuille de calcul.
- Masquer les barres de défilement horizontales et verticales de la vue du classeur.
This file contains hidden or 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 Workbook | |
| from aspose.pydrawing import Color | |
| # Instantiating an Workbook object | |
| workbook = Workbook() | |
| # Obtaining the reference of the newly added worksheet | |
| ws = workbook.worksheets[0] | |
| cells = ws.cells | |
| # Setting the value to the cells | |
| cell = cells.get("A1") | |
| cell.put_value("Fruit") | |
| cell = cells.get("B1") | |
| cell.put_value("Count") | |
| cell = cells.get("C1") | |
| cell.put_value("Price") | |
| cell = cells.get("A2") | |
| cell.put_value("Apple") | |
| cell = cells.get("A3") | |
| cell.put_value("Mango") | |
| cell = cells.get("A4") | |
| cell.put_value("Blackberry") | |
| cell = cells.get("A5") | |
| cell.put_value("Cherry") | |
| cell = cells.get("B2") | |
| cell.put_value(5) | |
| cell = cells.get("B3") | |
| cell.put_value(3) | |
| cell = cells.get("B4") | |
| cell.put_value(6) | |
| cell = cells.get("B5") | |
| cell.put_value(4) | |
| cell = cells.get("C2") | |
| cell.put_value(5) | |
| cell = cells.get("C3") | |
| cell.put_value(20) | |
| cell = cells.get("C4") | |
| cell.put_value(30) | |
| cell = cells.get("C5") | |
| cell.put_value(60) | |
| cell = cells.get("E10") | |
| temp = workbook.create_style() | |
| temp.font.color = Color.red | |
| cell.set_style(temp) | |
| # Hide horizontal and vertical scrollbars | |
| workbook.settings.is_h_scroll_bar_visible = False | |
| workbook.settings.is_v_scroll_bar_visible = False | |
| workbook.save("out.xlsx") |
Aperçu du fichier résultat:
