[Python知识库]Python批量生成Execl报表

一、代码块

import xlwt
import faker
import random

def creat_exexel_filr(filename,department):  #文件名，部门名
    wb=xlwt.Workbook(filename)   # 将传入的文件名，创建为新的工作簿
    sheet=wb.add_sheet("sheet")   # 在工作簿中创建表
    fake=faker.Faker("zh_CN")  #准备虚假的数据对象，设置语言为中文
    head_data=['部门','姓名','工号','薪资','奖金','实发工资']
    for head in head_data:# 写入头部信息
        sheet.write(0,head_data.index(head),head)
    for i in  range(1,random.randint(5,100)):
        sheet.write(i,0,department)
        sheet.write(i,1,fake.last_name()+fake.first_name())
        sheet.write(i,2,"G{}".format(random.randint(1,1000)))
        sheet.write(i,3,random.randint(4000,16000))
        sheet.write(i,4,random.choice([200,300,400,500,600]))
    wb.save(filename)

department_name=['技术部','推广部','客服部','行政部']
for dep in department_name:
    xls_name="{}.xls".format(dep)
    creat_exexel_filr(xls_name,dep)
    print(xls_name,"新建完成")

二、运行结果