大橙子网站建设,新征程启航
为企业提供网站建设、域名注册、服务器等服务
wb = Workbook()
ws = wb.create_sheet('月度排名汇总', 0)
# 合并单元格
ws.merge_cells('b2:b3')
ws.merge_cells('c2:c3')
ws.merge_cells('d2:d3')
ws.merge_cells('e2:g2')
ws.merge_cells('h3:j2')
# 设置单元格文本内容
ws['b2'].value = '负责人'
ws['c2'].value = '部门/小组'
ws['d2'].value = '负责产品总量'
ws['e2'].value = '与初始排名比较'
ws['h3'].value = '与月初排名比较'
ws['e3'].value = ws['h4'].value = '排名提升'
ws['f3'].value = ws['i3'].value = '排名不变'
ws['g3'].value = ws['j3'].value = '排名下滑'
# 创建单元格样式对象
headerCellStyle = NamedStyle(name = 'headerCellStyle')
headerCellStyle.alignment = Alignment(horizontal = 'center', vertical = 'center') # 水平垂直居中
border = Side(border_style = 'thin', color = '000000') # 线框样式
headerCellStyle.border = Border(left = border, top = border, right = border, bottom = border) # 设置单元格边框样式
# 设置表格样式
for row in ws['b2:j30']:
for cell in row:
cell.style = headerCellStyle
# 数据写入
for index, item in enumerate(data, 4):
ws.cell(row = index, column = 2, value = item.get('name'))
ws.cell(row = index, column = 3, value = item.get('group_name'))
ws.cell(row = index, column = 4, value = item.get('total'))
ws.cell(row = index, column = 5, value = item.get('initial').get('up'))
ws.cell(row = index, column = 6, value = item.get('initial').get('normal'))
ws.cell(row = index, column = 7, value = item.get('initial').get('down'))
ws.cell(row = index, column = 8, value = item.get('month').get('up'))
ws.cell(row = index, column = 9, value = item.get('month').get('normal'))
ws.cell(row = index, column = 10, value = item.get('month').get('down'))
wb.save('rank.xlsx')
另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。