#万万没想到从word复制ctrl+c一个表格粘贴ctrl+v到excel这么费事,最后粘贴还有点问题,定位不到想要的单元格。
from win32com import client
import win32clipboard as wc
import win32com.client
excel = client.Dispatch("Excel.Application")
excel.Visible = False
wb = excel.Workbooks.Open(r'D:\py\py\py-toword\text1.xlsx')
word = win32com.client.Dispatch('Word.Application')
word.Visible = False
doc = word.Documents.Open(r'D:\py\py\py-toword\test.docx')
tables=word.ActiveDocument.Tables
for table in tables:
table.Select()
word.Selection.Copy()
wb.ActiveSheet.Paste(wb.Worksheets("Sheet1").Range("g1"))
wc.OpenClipboard()
wc.EmptyClipboard()
wc.CloseClipboard()
wb.Save()
wb.Close()
doc.Save()
doc.Close()