win32com：word操作之 从excel复制表格到word

from win32com import client

import win32clipboard as wc

excel = client.Dispatch("ket.Application")
excel.Visible = False
wb = excel.Workbooks.Open(r'C:\Users\meiya\PycharmProjects\copyExcelToWord_V2\功能列表.xlsx')

doc_app = client.Dispatch("kwps.Application")
doc_app.Visible = False
doc = doc_app.Documents.Open(r'C:\Users\meiya\PycharmProjects\copyExcelToWord_V2\CFIT-SDP0302_XX项目产品规格说明书模板(1).docx')

sheet = wb.Worksheets[0]
sheet.UsedRange.Cells.Copy()

r = doc.Range(doc.Range().End-1)
r.Paste()

# 清空粘贴板
wc.OpenClipboard()
wc.EmptyClipboard()
wc.CloseClipboard()

wb.Close()
doc.Save()
doc.Close()