拆分表格
import openpyxlimport os
wb = openpyxl.load_workbook('英雄联盟人物.xlsx', data_only=True)
ws = wb.worksheets
rngs = list(ws.values)
d = {}
a = 3 #需要拆分的列号
for row in rngs:
if row in d.keys():
d] +=
else:
d.update({row: })
for k, v in d.items():
nwb = openpyxl.Workbook()
nws = nwb.active
nws.title = k
nws.append(rngs)
for r in v:
nws.append(r)
os.makedirs("统计汇总表", exist_ok=True)
nwb.save('统计汇总表/'+k+'.xlsx')
按照某一列分类拆分
页:
[1]