合并多个releaseNote文件内容，每个文件只有一个sheet页

# -*- coding:UTF-8 -*-
# python_version:3.x
"""
合并多个releaseNote文件内容，每个文件只有一个sheet页
"""
import xlrd
import xlwt
import os

if __name__=="__main__":
    dir = r"D:\workspace\handle_files\excel"
    #存储要合并的文件
    allxls = []
    for root, dirs, files in os.walk(dir):
        for file in files:
            allxls.append(os.path.join(root,file))
            # print(allxls)
    #存储读取的结果
    frames = []
    for file in allxls:
        data = xlrd.open_workbook(file)
        sh = data.sheet_names()
        row_num = data.sheet_by_name(sh[0]).nrows
        for i in range(row_num):
            row_con = data.sheet_by_name(sh[0]).row_values(i)
            # print(row_con)
            if "TRACE" in row_con[0]:
                frames.append(row_con)
                print(row_con)
    # 创建合并后的结果表
    end_xlsx = "D:\workspace\handle_files\releaseNote.xlsx"
    wb = xlwt.Workbook(end_xlsx)
    sheetname = wb.add_sheet("ALL")
 title = ['issueNum','description&reason','modify']
    for i in range(len(title)):
        sheetname.write(0, i, title[i])

    # 原文件内容写入结果表
    for i in range(len(frames)):
        for j in range(len(frames[i])):
            # print(frames[i][j])
            sheetname.write(i+1, j, frames[i][j])
    wb.save(r"D:\workspace\handle_files\releaseNote.xlsx")