功能:依照工作表中的不同部分对整张表进行分组排序
#!/usr/bin/env python
# --*-- coding:utf8 --*--
# Author: ZHangbb
import openpyxl
import time
t1 = time.time()
wb1 = openpyxl.load_workbook(r‘/home/wzr/音乐/leili.xlsx‘)
sh1 = wb1[‘诚利、科技‘]
# create a new sheet
wb1.create_sheet(‘诚利、科技-1‘)
sh2 = wb1[‘诚利、科技-1‘]
# department list
dept_list = []
# generate data of department
for cell in [col for col in sh1.columns][4]:
dept_list.append(cell.value)
# get the unique value
dept_list = list(set(dept_list))
dept_list.sort()
dept_list.remove(‘部门‘)
# print department information
for dept in dept_list:
print(dept, end=" ")
# write the table header to the first of the new sheet
for col in range(1, 15):
sh2[chr(64+col