Python Write Excel xlsx File with Merged Cells using OpenPyXL
In this Python openpyxl tutorial we learn how to write Excel xlsx files with merged cells using the openpyxl package.
How to install the openpyxl package
To install the openpyxl package using the command below.
pip install openpyxl
How to write Excel xlsx file with merged cells
Import the Workbook from the openpyxl package.
from openpyxl import Workbook
Create a new Workbook object.
wb = Workbook()
Get the default active Worksheet object.
ws = wb.active
Merge cells from B2 to D2.
Assign value for the merged cell.
ws['B2'] = 'Tori Code'
Save the Workbook as merge_cells.xlsx file.
The complete Python program as below.
from openpyxl import Workbook wb = Workbook() ws = wb.active ws.merge_cells('B2:D2') ws['B2'] = 'Tori Code' wb.save('merge_cells.xlsx')
Execute the above Python program we will get the Excel file merge_cells.xlsx as below screenshot.
Happy Coding 😊