How To Unmerge Cell Ranges Using OpenPyXL?

Method

Use the `unmerge_cells` method to unmerge cells.

ws.unmerge_cells(range_string=None,start_row=None,start_column=None,end_row=None,end_column=None)

Sample Code

# Unmerge Cell Ranges

#Import load_workbook function
from openpyxl import Workbook

#Create a new workbook
wb=Workbook()
#Get the active worksheet
ws=wb.active

#Unmerge a cell range
ws.unmerge_cells('C3:E4')
#ws.unmerge_cells(start_row=3, start_column=3, \
#    end_row=4, end_column=5)

wb.save('test.xlsx')
wb.close()