ワークシート内の結合セルを検出
Contents
[
Hide
]
この記事では、ワークシート内の結合セル領域を取得する方法について説明しています。
Aspose.Cells for Python via .NETは、ワークシート内の結合セル領域を取得できます。これらを解除(分割)することも可能です。この記事では、最も簡単なコード例を使って、Aspose.Cells APIを使用したこの作業を実行する方法を示します。
このコンポーネントは、すべての結合セルを取得できるCells.get_merged_areas()メソッドを提供します。以下のコード例は、ワークシート内の結合セルを検出する方法を示しています。
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 import pycore | |
from aspose.cells import CellArea, 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(".") | |
# Instantiate a new Workbook | |
# Open an existing excel file | |
wkBook = Workbook(dataDir + "SampleInput.xlsx") | |
# Get a worksheet in the workbook | |
wkSheet = wkBook.worksheets.get("Sheet2") | |
# Clear its contents | |
wkSheet.cells.clear() | |
# Create an arraylist object | |
al = [] | |
# Get the merged cells list to put it into the arraylist object | |
al = wkSheet.cells.merged_cells | |
# Loop through the arraylist and get each cellarea | |
# To unmerge it | |
for i in range(len(al)): | |
ca = CellArea() | |
ca = pycore.cast(CellArea, al[i]) | |
frow = ca.start_row | |
fcol = ca.start_column | |
erow = ca.end_row | |
ecol = ca.end_column | |
trows = erow - frow + 1 | |
tcols = ecol - fcol + 1 | |
wkSheet.cells.un_merge(frow, fcol, trows, tcols) | |
dataDir = dataDir + "MergeTrial.out.xlsx" | |
# Save the excel file | |
wkBook.save(dataDir) |