会python真的可以为所欲为0(回)
352天前
这里还有人吗1(回)
538天前这里还有人吗0(回)
538天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
762天前到处都是羊，不想上班0(回)
842天前
鸽子
0(回)
846天前# 处理人员信息2,将同一类数据合并 |
import xlrd, xlwt |
from xlutils.copy import copy |
people = [] |
def start(): |
data = xlrd.open_workbook(r"C:\Users\Administrator\Desktop\test.xlsx") |
newb = copy(data) |
table = data.sheet_by_name(r"Sheet1") |
title = table.row_values(1) |
nrows = table.nrows |
for h in range(2, nrows): |
values = table.row_values(h) |
people.append(dict(zip(title, values))) |
worksheet = newb.add_sheet('修改后') |
style = xlwt.XFStyle() # 初始化样式 |
font1 = xlwt.Font() # 为样式创建字体 |
font1.name = '宋体' |
font1.height = 20 * 11 |
font1.bold = False |
style.font = font1 |
worksheet.write(1, 0, '姓名', style) # 带样式的写入 |
worksheet.write(1, 1, '数据', style) |
worksheet.write(1, 2, '电话', style) |
wl = 2 |
name_t = people[0]['姓名'] |
data_t = people[0]['数据'] |
phone_t=people[0]['电话'] |
for peop in people[1:]: |
if peop['姓名'] == name_t: |
data_t = data_t + "、" + peop['数据'] |
else: |
worksheet.write(wl, 0, name_t, style) |
worksheet.write(wl, 1, data_t, style) |
worksheet.write(wl, 2, phone_t, style) |
wl=wl+1 |
name_t=peop['姓名'] |
data_t=peop['数据'] |
phone_t=peop['电话'] |
worksheet.write(wl, 0, name_t, style) |
worksheet.write(wl, 1, data_t, style) |
worksheet.write(wl, 2, phone_t, style) |
newb.save(r'C:\Users\Administrator\Desktop\test.xlsx') |
if __name__ == '__main__': |
start() |
