合并或取消合并单元格范围
Contents
[
Hide
]
可能的使用场景
您可以使用Aspose.Cells for Python via .NET来合并或拆分一系列单元格。Aspose.Cells for Python via .NET提供了Range.merge()和Range.un_merge()方法来实现这一目的。本文解释了如何将一系列单元格合并为单个单元格。
如何合并或拆分单元格范围
以下示例代码首先创建范围 - A1:D4 - 然后使用 Range.merge() 方法将范围中的单元格合并为单个单元格。类似地，您可以通过创建范围并调用 Range.un_merge() 方法来拆分单元格。
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 | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # The path to the documents directory. | |
| dataDir = RunExamples.GetDataDir(".") | |
| # Create a workbook | |
| workbook = Workbook() | |
| # Access the first worksheet | |
| worksheet = workbook.worksheets[0] | |
| # Create a range | |
| range = worksheet.cells.create_range("A1:D4") | |
| # Merge range into a single cell | |
| range.merge() | |
| # Save the workbook | |
| workbook.save(dataDir + "output.out.xlsx") |