openpyxl合并单元格

代码

import openpyxl

wb = openpyxl.load_workbook('/Users/test0712.xlsx')
ws = wb['Sheet1']
max_rows = ws.max_row  # 获取最大行
max_columns = ws.max_column  # 获取最大列

# openpyxl的下标从1开始

ws.merge_cells(range_string='A1:B3')  # 合并单元格A1:B3

wb.save('/Users/test0712.xlsx')

合并前

合并后