Hur man Kontrollerar Workbook View
Contents
[
Hide
]
Möjliga användningsscenario
När du behöver justera visningen av Excel-sidor, måste du veta hur du kontrollerar varje modul, som horisontella och vertikala rullningsfält, om du vill dölja öppna Excel-filer osv. Aspose.Cells erbjuder denna funktion. Aspose.Cells tillhandahåller följande egenskaper och metoder för att hjälpa dig att uppnå dina mål.
- 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
Hur man Kontrollerar Workbook View med Aspose.Cells for .NET
Detta exempel visar hur man:
- Skapa en arbetsbok.
- Lägga till data till celler i den första arbetsboken.
- Dölj horisontella och vertikala rullningsfält för Workbook View.
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") |
Förhandsgranskning av resultatfil:
