Cacher is the code snippet organizer for pro developers

    def merge_head_date_body(self, filelocation, filename):
        fileform = 'xls'  # 文件夹下搜索的文件后缀名
        filearray = []
        for excelname in glob.glob(filelocation + '*.' + fileform):
            excel_base_name = os.path.basename(excelname)  # 获取文件名称
            filearray.append(excel_base_name)
        excel_num = len(filearray)  # 获取excel的个数
        excelarray = []
        img_base_name = os.path.basename(filename)  # 获取文件名称
        new_dir_name, extend_name = os.path.splitext(img_base_name)  # 将文件名与扩展名分割
        # 将excel的文件名称按顺序存入excelarray
        excelname = filelocation + new_dir_name +'_rgb_head.jpg.xls'
        excelarray.append(excelname)
        excelname = filelocation + new_dir_name + '_rgb_date.jpg.xls'
        excelarray.append(excelname)
        excelname = filelocation + new_dir_name +'_rgb_body.jpg.xls'
        excelarray.append(excelname)
        print(excelarray)

        datavalue=[]

        for excel_file in excelarray:
            final_value=self.get_file(excel_file,datavalue)
        # print(final_value)

        # 新的Excel文件

        workbook = xlwt.Workbook()
        print(filename)
        # 创建一个sheet对象
        worksheet = workbook.add_sheet("whole")
        for i in range(len(final_value)):
            for j in range(len(final_value[i])):
                worksheet.write(i, j, final_value[i][j])
                # print(  i, j, final_value[i][j] )
        workbook.save(filename+".xls")
        print("合并结束.........")



    def get_file(self,file, data_value):
        fh =xlrd.open_workbook(file)
        if fh.sheets()[0].name=="body":
            table =fh.sheets()[0]
            rows = table.nrows
            for row in range(rows):
                data = table.row_values(row)
                data_value.append(data)
            return data_value