Wie man die Ansicht der Arbeitsmappe steuert
Contents
[
Hide
]
Mögliche Verwendungsszenarien
Wenn Sie die Anzeige der Excel-Seiten anpassen müssen, müssen Sie wissen, wie Sie jedes Modul steuern können, z. B. horizontale und vertikale Bildlaufleisten, ob Excel-Dateien geöffnet werden sollen usw. Aspose.Cells bietet diese Funktion. Aspose.Cells bietet die folgenden Eigenschaften und Methoden, um Ihnen bei der Erreichung Ihrer Ziele zu helfen.
- 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
Wie man die Ansicht der Arbeitsmappe mithilfe von Aspose.Cells for .NET steuert
Dieses Beispiel zeigt, wie Sie:
- Ein Arbeitsbuch erstellen.
- Daten zu Zellen im ersten Arbeitsblatt hinzufügen.
- Horizontale und vertikale Bildlaufleisten der Arbeitsbuchansicht ausblenden.
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") |
Vorschau der Ergebnisdatei:
