Python win32com操作Excel：检测并退出单元格编辑状态

Absolutely, you can detect and exit Excel's cell edit mode programmatically with Python—here's how to fix that frustrating error:

Why the Error Happens #

When Excel is in cell edit mode (cursor blinking inside a cell), the COM interface locks down many operations. The gencache.EnsureDispatch method tries to generate a typed wrapper for the Excel object, which fails because Excel isn't in a state to respond to that request, hence the TypeError.

Step-by-Step Solution #

We'll combine two key actions:

1. Catch the initial error to detect edit mode
2. Force Excel to exit edit mode, then retry the connection

Here's the revised code with error handling and edit mode exit logic:

import win32com.client as win32
import win32api
import win32con
import win32gui
import time

def find_excel_main_window():
    """Find the main window handle for the running Excel instance"""
    hwnd_list = []
    def window_callback(hwnd, extra):
        if win32gui.GetWindowText(hwnd).startswith("Microsoft Excel"):
            extra.append(hwnd)
        return True
    win32gui.EnumWindows(window_callback, hwnd_list)
    return hwnd_list[0] if hwnd_list else None

def exit_excel_edit_mode():
    """Send ESC key to Excel to exit cell edit mode"""
    excel_hwnd = find_excel_main_window()
    if excel_hwnd:
        # Send ESC key down and up messages to the Excel window
        win32api.SendMessage(excel_hwnd, win32con.WM_KEYDOWN, win32con.VK_ESCAPE, 0)
        win32api.SendMessage(excel_hwnd, win32con.WM_KEYUP, win32con.VK_ESCAPE, 0)
        time.sleep(0.2)  # Give Excel time to process the key press

# Attempt to connect to Excel, handle edit mode error
try:
    excel = win32.gencache.EnsureDispatch('Excel.Application')
except TypeError as e:
    # This error likely means Excel is in edit mode
    print("Detected Excel in edit mode—exiting now...")
    exit_excel_edit_mode()
    # Retry the connection after exiting edit mode
    excel = win32.gencache.EnsureDispatch('Excel.Application')

# Proceed with your normal operations
wb = excel.Workbooks.Open(r'C:\Users\Patrick\Desktop\PyWin32.xlsx')
ws = wb.Worksheets("Tabelle1")

# Optional: Double-check edit mode before writing (safety net)
try:
    ws.Cells(2, 2).Value = 123
except Exception as write_error:
    print("Write failed—checking for edit mode again...")
    exit_excel_edit_mode()
    ws.Cells(2, 2).Value = 123

# Clean up (adjust based on your needs)
wb.Save()
wb.Close()
excel.Quit()

Key Details #

• find_excel_main_window: Locates Excel's main window using win32gui.EnumWindows, so we can send keys directly to it without needing to bring Excel to the foreground.
• exit_excel_edit_mode: Uses win32api.SendMessage to send the ESC key to Excel—this is more reliable than keybd_event because it targets Excel specifically, not the active window.
• Error Handling: We catch the initial TypeError to trigger the edit mode exit, then retry the connection. We also add a safety net around the write operation in case edit mode is reactivated between connection and writing.

Alternative: Pre-emptive Check #

If you want to check for edit mode before any operations (instead of catching errors), you can use the Ready property—though note this might not be 100% reliable in all cases:

def is_excel_in_edit_mode(excel_app):
    try:
        return not excel_app.Ready
    except:
        return True  # If we can't access Ready, assume edit mode

Just call this before your write operations and run exit_excel_edit_mode() if it returns True.

内容的提问来源于stack exchange，提问作者Patrick T.