Merge and Unmerge Cells in Excel using Python

merge-cells-in-excel-using-python.md

Learn how to Merge and Unmerge Cells in Excel using Python

merge-cells-in-excel-using-python_merge_range

import aspose.cells as cells

# Create a new workbook
workbook = cells.Workbook()

# Access the first worksheet
worksheet = workbook.worksheets.get(0)

# Create a Range
range = worksheet.cells.create_range("A1:D4")

# Merge range into a single cell
range.merge()

# Save the workbook
workbook.save("MergeRangeOfCells.xlsx")

merge-cells-in-excel-using-python_simple_merge.py

import aspose.cells as cells

# Create a new workbook
workbook = cells.Workbook()

# Access the first worksheet
worksheet = workbook.worksheets.get(0)

worksheet_cells = worksheet.cells

# Merge cells A1 to C1
worksheet_cells.merge(0, 0, 1, 3);

# Save the workbook
workbook.save("MergedCells.xlsx")

merge-cells-in-excel-using-python_simple_unmerge.py

import aspose.cells as cells

# Load a workbook
workbook = cells.Workbook("MergedCells.xlsx")

# Access the first worksheet
worksheet = workbook.worksheets.get(0)

worksheet_cells = worksheet.cells

# Unmerge cells A1 to C1
worksheet_cells.un_merge(0, 0, 1, 3);

# Save the workbook
workbook.save("UnmergedCells.xlsx")

merge-cells-in-excel-using-python_unmerge_range.py

import aspose.cells as cells

# Create a new workbook
workbook = cells.Workbook("MergeRangeOfCells.xlsx")

# Access the first worksheet
worksheet = workbook.worksheets.get(0)

# Create a Range
range = worksheet.cells.create_range("A1:D4")

# Merge range into a single cell
range.un_merge()

# Save the workbook
workbook.save("UnmergeRangeOfCells.xlsx")