如何用Python将Excel表格追加到Word文档而非覆盖原有内容？

The problem with your current code is that doc.Content.PasteExcelTable() targets the entire content of the Word document, which replaces everything that was there before. To append the table instead, you need to paste it at the end of the existing document rather than overwriting the whole content.

Here's the revised code with clear explanations:

from win32com import client

# Initialize Excel and Word applications
excel = client.Dispatch("Excel.Application")
word = client.Dispatch("Word.Application")

# Optional: Make Word visible to see the process in action (helpful for debugging)
word.Visible = True

# Open your existing Word document
doc = word.Documents.Open("C:/word_file.docx")

# Open the Excel workbook and select the target table range
book = excel.Workbooks.Open("C:/excel_file.xlsx")
sheet = book.Worksheets(1)
sheet.Range("A1:D20").Copy()  # Copy your desired Excel table range

# Get the end position of the Word document to append the table
# Subtract 1 from Content.End to avoid pasting after an extra final paragraph mark
end_range = doc.Range(doc.Content.End - 1, doc.Content.End - 1)

# Paste the Excel table at the end of the document
# Parameters breakdown:
# - LinkToExcel: False = don't link the table to the original Excel file
# - WordFormatting: True = keep Excel's original formatting (colors, borders, fonts)
# - RTF: False = use native table format instead of RTF
end_range.PasteExcelTable(LinkToExcel=False, WordFormatting=True, RTF=False)

# Clean up resources to avoid leaving background processes running
book.Close(SaveChanges=False)  # Skip saving Excel unless you made edits
excel.Quit()
doc.Save()  # Save the updated Word document
doc.Close()
word.Quit()

# Optional: Release COM objects to prevent memory leaks
del sheet, book, excel, end_range, doc, word

Key Fixes & Notes: #

• Targeting the document end: Instead of overwriting doc.Content, we create a Range object that points to the very end of existing content. This ensures the table is added after what’s already in the document.
• Preserving formatting: Setting WordFormatting=True keeps your Excel table’s original styles intact. Switch to False if you want the table to inherit Word’s default formatting.
• Resource cleanup: Always close workbooks/documents and quit the applications—otherwise Excel or Word might keep running silently in the background.

内容的提问来源于stack exchange，提问作者Seemab Hassan