使用win32com和Python将Excel数据粘贴到特定的MS Word段落中

import win32com.client as win32
from openpyxl import load_workbook

word_app = win32.Dispatch("Word.Application")
word_app.Visible = True
word_doc = word_app.Documents.Open("path/to/word/document.docx")

excel_workbook = load_workbook("path/to/excel/file.xlsx")
excel_sheet = excel_workbook.active

# 假设要粘贴的Excel数据位于第一个工作表的A1到C5范围内
data = []
for row in excel_sheet.iter_rows(min_row=1, max_row=5, min_col=1, max_col=3):
    row_data = [cell.value for cell in row]
    data.append(row_data)

target_paragraph = "This is the target paragraph"  # 替换为目标段落的文字

for paragraph in word_doc.Paragraphs:
    if target_paragraph in paragraph.Range.Text:
        for row in data:
            paragraph.Range.InsertAfter("\t".join(str(cell) for cell in row))
            paragraph.Range.InsertParagraphAfter()
        break

word_doc.Save()
word_doc.Close()