How To Merge Cell Ranges Using OpenPyXL?

Method

Use the `merge_cells` method of the worksheet object to merge cells:

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

Sample Code

#Merge Cell Ranges

#Import load_workbook function
from openpyxl import Workbook

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

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

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