表格合并

多个Excel表格，里包含各种样式，把多个表格合并成一个

from win32com.client import Dispatch

path1 = r'表格的路径'
path2 = r'表格的路径'

ex1 = Dispatch("Excel.Application")  #打开Excel应用程序
ex1.Visible = True  # 将True改成false可以隐藏excel的操作可见性

wb1 = ex1.Workbooks.Open(Filename=path1)
wb2 = ex1.Workbooks.Open(Filename=path2)

ws1 = wb1.Worksheets(1)
ws1.Copy(Before=wb2.Worksheets(1))

wb2.Close(SaveChanges=True)
ex1.Quit()