【Python】openpyxl单元格合并

from openpyxl import Workbookwb &＃61; Workbook()
ws &＃61; wb.active
# 需要合并的左上方和右下方单元格坐标
ws.merge_cells(range_string&＃61;&＃39;A1:B3&＃39;)
ws.merge_cells(start_row&＃61;5, start_column&＃61;4, end_row&＃61;8, end_column&＃61;8)# 单元格取消合并使用unmerge_cells
ws.unmerge_cells(range_string&＃61;&＃39;A1:B3&＃39;)
ws.unmerge_cells(start_row&＃61;5, start_column&＃61;4, end_row&＃61;8, end_column&＃61;8)

常用合并merge_cells和取消合并unmerge_cells方法调用示例。

转载&＃xff1a;openpyxl单元格合并_BDawn的博客-CSDN博客_openpyxl合并单元格

openpyxl的单元格合并会把合并区域左上角单元格的值赋给合并之后的单元格&＃xff0c;如果这个单元格没有值&＃xff0c;即使区域内其他单元格有值&＃xff0c;合并后的单元格也是空白
下面写了一个函数用来解决这个问题&＃xff0c;这个函数会合并单元格并且将合并区域最上边最左边有值的单元格赋值给合并后的单元格

from openpyxl import Workbook
from openpyxl.utils import get_column_letterdef merge_cells_value(sheet&＃61;None, range_string&＃61;None, start_row&＃61;None, start_column&＃61;None, end_row&＃61;None, end_column&＃61;None):"""将靠上靠左的单元格的value赋值给合并后的单元格"""if start_row > end_row:fmt &＃61; "{end_row} must be greater than {start_row}"raise ValueError(fmt.format(start_row&＃61;start_row, end_row&＃61;end_row))if start_column > end_column:fmt &＃61; "{end_column} must be greater than {start_column}"raise ValueError(fmt.format(start_column&＃61;start_column, end_column&＃61;end_column))if range_string is None:fmt &＃61; &＃39;{start_column}{start_row}:{end_column}{end_row}&＃39;range_string &＃61; fmt.format(start_row&＃61;start_row,start_column&＃61;get_column_letter(start_column),end_row&＃61;end_row,end_column&＃61;get_column_letter(end_column))v &＃61; Nonefor cells in sheet[range_string]:for cell in cells:if cell.value is not None:v &＃61; cell.valuebreakif v is not None:breakprint(range_string)sheet.merge_cells(range_string&＃61;range_string)sheet[&＃39;{0}{1}&＃39;.format(get_column_letter(start_column), str(start_row))] &＃61; v
# 使用方式wb &＃61; Workbook()
ws &＃61; wb.activemerge_cells_value(sheet&＃61;ws, start_row&＃61;5, start_column&＃61;4, end_row&＃61;8, end_column&＃61;8)