如何控制工作簿视图
Contents
[
Hide
]
可能的使用场景
当您需要调整Excel页面的显示时，您需要知道如何控制每个模块，例如水平和垂直滚动条，是否隐藏打开的Excel文件等。Aspose.Cells提供了此功能。
- 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
使用Aspose.Cells for .NET了解如何控制工作簿视图。
此示例演示如何：
- 创建一个工作簿。
- 在第一个工作表中的单元格中添加数据。
- 隐藏工作簿视图的水平和垂直滚动条。
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") |
结果文件预览：
