python按需生成excel表格

import xlrd
import xlwt
def excel_copy(dir_from, sheet_list,esxi_cpu_mem_lst,vfos_net_ck_lst,vm_perf_ip_cpu_mem_lst,net_mon_lst,ip_used_rate_lst):
    '''从一个excel写入到另外一个excel'''
    wb = xlrd.open_workbook(dir_from)
    workbook = xlwt.Workbook(encoding="utf-8")
    vm_ip_lst,vm_cpu_lst,vm_mem_lst=split_vm_perf_lst(vm_perf_ip_cpu_mem_lst)#def_str_1 data
    vfos_ck_ip_lst,vfosv3_ck_rst_lst,vfosv5_ck_rst_lst=split_vm_perf_lst(vfos_net_ck_lst)#def_str_4 data
    ip_used_rate_max_count=sum_max_count(ip_used_rate_lst)
    def_str_1='利用率'.decode('gbk').encode('utf-8').decode('utf-8')
    def_str_2='内存监控'.decode('gbk').encode('utf-8').decode('utf-8')
    def_str_3='网络故障统计'.decode('gbk').encode('utf-8').decode('utf-8')
    def_str_4='vfos虚拟机扫描'.decode('gbk').encode('utf-8').decode('utf-8')
    def_str_5='网络空余地址扫描'.decode('gbk').encode('utf-8').decode('utf-8')
    # 选择sheet页
    k=0
    while k<len(sheet_list):
        #pdb.set_trace()
        sheet_name=sheet_list[k]
        sheet1 = wb.sheet_by_name(sheet_name)
        # 打印每个sheet页的行数
        # print("sheet1行数：%d" % sheet1.nrows)
        # 创建写入文件
        # 创建写入sheet页

        pattern = xlwt.Pattern()  # Create the pattern
        pattern.pattern = xlwt.Pattern.SOLID_PATTERN  # May be: NO_PATTERN, SOLID_PATTERN, or 0x00 through 0x12
        pattern.pattern_fore_colour = 1  # May be: 8 through 63. 0 = Black, 1 = White, 2 = Red, 3 = Green, 4