Python将excel数据合并居中，跳过空单元

导入模块：

代码如下：

"""合并单元格"""

result_file = "C:/Users/GW00327267/Desktop/data.xlsx"

wb = load_workbook(result_file)

ws = wb['Sheet1']

flag = type_list[0]

for i in range(len(type_list)):

if type_list[i] != flag:

flag = type_list[i]

e = i - 1

if e >= s:

ws.merge_cells("A" + str(s + 2) + ":A" + str(e + 2)) # C为列

s = e + 1

if i == len(type_list) - 1:

e = i

ws.merge_cells("A" + str(s + 2) + ":A" + str(e + 2))

#居中

alignment = Alignment(horizontal='center', vertical='center')

WR_area = ws["A1:A500"]

for i in WR_area:

for j in i:

j.alignment = alignment

wb.save(result_file)

效果：

希望对你有用！