Unmerging the cells in an excel file using Python

Step 1: Import the required packages.

import openpyxl
import os      # for reading the excel file.

Step 2:Open the Excel Working using the load_workbook function from openpyxl.This function accepts a path as a parameter and opens the Excel File.

Here, we are first storing the path of the Excel File in a PATH variable. The name of our Excel File is sample.xlsx and it is presenting the current working directory. So we do something like this:

path=os.path.join(os.getcwd(),"sample.xlsx")

Now, let’s load the workbook into our Python code. and open the currently active workbook from it.

wb=openpyxl.load_workbook(path)
ws=wb.active

Step 3:Unmerging the cells.

As we can see initially the worksheet looks like this:

Here, the cells B1:E2 are merged into a single cell. Let’s unmerge these cells.

To do so, we use the unmerge_cells function from openpyxl which takes the following parameters:

1.start_row: Specifies the starting index of the row to start unmerging from.
2.start_column: Specifies the starting index of the row to start unmerging from.
3.end_row: Specifies the last index of the row to end unmerging.
4.end_column: Specifies the last index of the column to end unmerging.

Now, let’s use the function to unmerge row number 1 to 2 and column number 2 to 5 into individual cells.

ws.unmerge_cells(start_row=1, start_column=2, end_row=2, end_column=5)

After this step, the following worksheet will be produced.

Step 4:To save the changes, we can save the worksheet as:

wb.save(filename="sample.xlsx")

Final Code:

Output:

In this article, we are going to learn about Python programs to merge and unmerge excel cells using openpyxl.

Introduction

Openpyxl is a Python library commonly used for reading and writing Excel Files. In this article, we will be using this library to merge cells in Excel. Merging is helpful when we want to display some special information in order to gain user attention or to just properly display a long word properly. For example, Consider the following sheet. If you want to display a long title. By default, it will appear like this.

Here, we can see that before merging, the title appears to be meaningless and less user-friendly. However, if we merge some cells, the heading will appear much more clearly and read-friendly. After merging some adjacent cells, It will look something like this.

In this article, we are going to accomplish this task using Python.