按指定列拆分成多个工作表

from openpyxl import *
import openpyxl

wb = openpyxl.load_workbook('cpu.xlsx')
ws = wb.active
range = ws.iter_rows(min_row=2)
dict1 = {}
for row in range:
    each_row = [cell.value for cell in row]
    print(each_row)
    if each_row[1] in dict1.keys():
        dict1[each_row[1]] += [each_row]
    else:
        dict1[each_row[1]] = [each_row]

for key, value in sorted(dict1.items()):
    nws = wb.create_sheet(key)
    nws.append(['time', 'hostname', 'max_cpu_precent', 'agv_cpu_precent'])
    for data in value:
        nws.append(data)
wb.remove(wb['导出工作表'])
wb.remove(wb['SQL'])
wb.save('1.xlsx')

 

https://www.bilibili.com/video/BV1L5411W7wD?p=15