项目场景:
excle同一列数据相同合并
问题描述:
在excle里有大量的相同数据在同一列需要合并,手工太费时间:
解决方案:
import pandas as pd
from openpyxl import load_workbook
result_file = r'C:\Users\IT-huangyj\Desktop\出货数据 - 副本.xlsx'
wb = load_workbook(result_file)
ws = wb['出货信息']
# 获取第一列数据
type_list = []
i = 2
while True:
r = ws.cell(i, 1).value
if r:
type_list.append(r)
else:
break
i += 1
# 判断合并单元格的始末位置
s = 0
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))
s = e + 1
if i == len(type_list) - 1:
e = i
ws.merge_cells("A" + str(s + 2) + ":A" + str(e + 2))
wb.save(result_file)