win32com DispatchWithEvents属性错误：删gen_py后首次正常二次仍报错

I’ve run into this exact issue before—using win32com.client.Dispatch works fine, but WithEvents throws an AttributeError, and deleting the gen_py folder fixes it once, but the error comes back on the second run. Here’s how to resolve this permanently:

Why This Happens #

The gen_py folder stores auto-generated Python wrappers for COM type libraries. When you first delete it, win32com rebuilds the wrappers correctly for WithEvents. But on the second run, either:

• The program retains a reference to the old cached metadata in memory, or
• The newly regenerated gen_py files are incomplete or mismatched with the COM object’s expected interface.

Step-by-Step Fix #

You need to ensure the gen_py folder is fully deleted before importing win32com.client, and add safeguards to prevent residual cache issues. Here’s the complete code:

import os
import shutil
from shutil import rmtree

# Define the path to your gen_py folder
gen_py_path = r"C:\Users\omc\AppData\Local\Temp\gen_py"

# Delete the gen_py folder, ignoring errors if it doesn't exist
rmtree(gen_py_path, ignore_errors=True)

# Wait until the folder is completely gone—critical to avoid race conditions
while os.path.exists(gen_py_path):
    pass

# Now import win32com.client after cache is cleared
import win32com.client

# Optional: Force refresh the type library for your target COM object (e.g., Excel)
# win32com.client.gencache.EnsureDispatch("Excel.Application")

# Example usage with WithEvents
class ExcelEventHandler:
    def OnSheetChange(self, sheet, target_range):
        print(f"Sheet {sheet.Name} modified at {target_range.Address}")

# Create the COM object with event binding
excel_app = win32com.client.WithEvents(
    win32com.client.Dispatch("Excel.Application"),
    ExcelEventHandler
)
excel_app.Visible = True

Key Notes #

1. Import Order Matters: Always delete the cache before importing win32com.client. If you import win32com first, it’ll load the old cache before you can delete it.
2. Wait for Deletion: The while os.path.exists(...) loop ensures the folder is fully removed before proceeding—this prevents win32com from reading partially deleted files.
3. Force Type Library Refresh: If the error persists, uncomment the EnsureDispatch line. This forces win32com to regenerate the type library wrapper for your specific COM object, ensuring it matches what WithEvents expects.

内容的提问来源于stack exchange，提问作者Om Choudhary