python如何实现excel多表合并（附代码）

# -*- coding: utf-8 -*-

import xlrd

import xlwt

import os

import re

""" 写入工作本 """

def write_excel(path, write_sheet):

    # 加载工作本

    book = xlrd.open_workbook(path)

    # 获取表单

    read_sheet = book.sheet_by_name('Sheet1')

    # 遍历

    for row in  range(read_sheet.nrows):

        for col in  range(read_sheet.ncols):

            write_sheet.write(row, col, read_sheet.cell_value(row,col))

# 获取根目录下所有文件名

def walk(path):

  for root,dirs,names in os.walk(path):

    list = []

    for filename in names:

        path = os.path.join(root, filename)

        list.append(path)

    return list

if __name__ == "__main__":

    # 创建工作本

    write_book = xlwt.Workbook()

    # 根目录

    root = r'C:\mydata\generator\excel'

    path_list = walk(root)

    for path in path_list:

        val = path.find("本专科")

        if val!=-1:

        # 正则匹配

            ser = re.search('.*20200403(.*?).xls',path)

            name = ser.group(1)

            # 创建sheet

            write_sheet = write_book.add_sheet(name)

            # 写入

            write_excel(path, write_sheet)

    # 保存       

    write_book.save(r'本专科.xls')