Python中Excel转PDF后xlsx文件无法删除的问题求助

You’re exactly right about the root cause—your Excel file is locked by the background Excel process spawned by win32com.client.Dispatch, and the wb.close() you tried only affects the workbook object you used to create/save the XLSX (like from openpyxl or pandas), not the separate Excel instance you launched for the PDF conversion.

Here’s how to properly clean up the Excel process and release the file lock:

Step-by-Step Fix #

1. Close the opened workbook from the Dispatch instance first
2. Quit the entire Excel application to terminate the background process
3. Release COM object references to avoid lingering process handles

Modified Code #

import os
import win32com.client as client
import pythoncom

# Your existing code to save the XLSX
wb.save(NEW_RECEIPT_PATH + new_file_name_xlsx)
# Close the original workbook object if you're using a library like openpyxl/pandas
wb.close()

# Convert XLSX to PDF with proper cleanup
try:
    xlApp = client.Dispatch("Excel.Application")
    # Set Visible to False to avoid popping up Excel windows
    xlApp.Visible = False
    books = xlApp.Workbooks.Open(NEW_RECEIPT_PATH + new_file_name_xlsx)
    ws2 = books.Worksheets[0]
    save_the_pdf = NEW_RECEIPT_PATH + new_file_name_pdf
    # Export as PDF (0 = xlTypePDF)
    ws2.ExportAsFixedFormat(0, save_the_pdf)
finally:
    # Ensure cleanup even if an error occurs
    if 'books' in locals():
        # Close the workbook without saving changes (we don't need to modify it)
        books.Close(SaveChanges=False)
    if 'xlApp' in locals():
        # Quit the Excel application entirely
        xlApp.Quit()
        # Release COM object references
        del ws2, books, xlApp
        pythoncom.CoUninitialize()

# Now you can delete the XLSX file without issues
os.remove(NEW_RECEIPT_PATH + new_file_name_xlsx)

Why This Works #

• books.Close(SaveChanges=False): Closes the specific workbook you opened in the Dispatch instance, releasing its lock on the file.
• xlApp.Quit(): Terminates the background Excel process that was keeping the file open—this is the most critical step you were missing.
• The try/finally block ensures cleanup happens even if there’s an error during PDF conversion, preventing orphaned Excel processes from lingering in Task Manager.

Additional Tips #

• Always use absolute paths for NEW_RECEIPT_PATH to avoid Excel looking in the wrong directory (which can cause silent failures or locked files).
• Setting xlApp.Visible = False not only makes the process run in the background but also reduces the chance of user interaction accidentally keeping the file open.

内容的提问来源于stack exchange，提问作者James Novis