管理范围
Contents
[
Hide
]
介绍
在Excel中，您可以使用鼠标框选来选择多个单元格，所选的单元格集称为“范围”。
例如，您可以在Excel的单元格“ A1”中单击鼠标左键，然后拖动到单元格“ C4”。您选择的矩形区域也可以轻松地通过使用Aspose.Cells for Python via .NET创建为对象。
这里是如何创建范围、设置值、设置样式以及对“范围”对象进行更多操作。
使用Aspose.Cells for Python Excel库管理范围
Aspose.Cells for Python via .NET提供了一个代表Microsoft Excel文件的类，Workbook。Workbook类包含一个worksheets集合，允许访问Excel文件中的每个工作表。工作表由Worksheet类表示。Worksheet类提供了一个Cells集合。
如何创建范围
当您想创建覆盖 A1:C4 的矩形区域时，您可以使用以下代码：
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 Workbook | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # Create a Workbook | |
| workbook = Workbook() | |
| # Get Cells | |
| cells = workbook.worksheets[0].cells | |
| # Create Range | |
| range = cells.create_range("A1:C4") |
如何将值放入范围的单元格中
假设您有一个跨越A1:C4的单元格范围。矩阵构成了4 * 3 = 12个单元格。单个范围单元格是依次排列的。
以下示例展示如何向范围单元格输入一些值。
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 Workbook, Range | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # Create a Workbook | |
| workbook = Workbook() | |
| # Get Cells | |
| cells = workbook.worksheets[0].cells | |
| # Create Range | |
| range = cells.create_range("A1:C4") | |
| # Put value | |
| a1 = cells.get(range.first_row, range.first_column) | |
| a1.put_value("A1") | |
| b1 = cells.get(range.first_row, range.first_column + 1) | |
| b1.put_value("B1") | |
| c1 = cells.get(range.first_row, range.first_column + 2) | |
| c1.put_value("C1") | |
| a4 = cells.get(range.first_row + 3, range.first_column) | |
| a4.put_value("A4") | |
| b4 = cells.get(range.first_row + 3, range.first_column + 1) | |
| b4.put_value("B4") | |
| c4 = cells.get(range.first_row + 3, range.first_column + 2) | |
| c4.put_value("C4") | |
| # Save the Workbook | |
| workbook.save("RangeValueTest.xlsx") |
如何设置范围单元格的样式
以下示例展示如何设置范围单元格的样式。
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 BackgroundType, Workbook | |
| from aspose.pydrawing import Color | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # Create a Workbook | |
| workbook = Workbook() | |
| # Get Cells | |
| cells = workbook.worksheets[0].cells | |
| # Create Range | |
| range = cells.create_range("A1:C4") | |
| # Put value | |
| a1 = cells.get(range.first_row, range.first_column) | |
| a1.put_value("A1") | |
| c4 = cells.get(range.first_row + 3, range.first_column + 2) | |
| c4.put_value("C4") | |
| # Set Style | |
| style00 = workbook.create_style() | |
| style00.pattern = BackgroundType.SOLID | |
| style00.foreground_color = Color.red | |
| a1.set_style(style00) | |
| style32 = workbook.create_style() | |
| style32.pattern = BackgroundType.HORIZONTAL_STRIPE | |
| style32.foreground_color = Color.green | |
| c4.set_style(style32) | |
| # Save the Workbook | |
| workbook.save("RangeStyleTest.xlsx") |
如何获取范围的CurrentRegion
CurrentRegion 是一个返回代表当前区域的 Range 对象的属性。
当前区域是由任意组合空行和空列所限定的范围。只读。
在Excel中，您可以通过以下方式获取当前区域：
- 用鼠标框选一个区域（range1）。
- 点击“开始 - 编辑 - 查找和选择 - 特殊跳转 - 当前区域”，或使用“Ctrl+Shift+*”，您会看到Excel会自动帮您选择一个区域（range2），现在您已经成功选择了range2，它就是range1的当前区域。
使用Aspose.Cells for Python via .NET，您可以使用“Range.current_region”属性执行相同的功能。
请下载以下测试文件，在Excel中打开它，使用鼠标框选一个区域“A1:D7”，然后点击“Ctrl+Shift+*”，您会看到区域“A1:C3”被选中。
现在请运行以下示例，在Aspose.Cells for Python via .NET中查看其运行方式：
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 Workbook | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # Create a Workbook | |
| workbook = Workbook("current_region.xlsx") | |
| # Get Cells | |
| cells = workbook.worksheets[0].cells | |
| # Create Range | |
| src = cells.create_range("A1:D7") | |
| # Get CurrentRegion | |
| A1C3 = src.current_region |