关于subprocess.Popen后关闭文件及Python中with语句未关闭Excel工作簿的问题

Hey there! Let's break down your two issues and fix them step by step:

1. Why the with statement isn't closing your Excel workbook (Stephan's solution) #

First off, let's clarify: the with statement works great for objects that implement Python's context manager protocol, but most Excel COM objects (like Workbook from win32com.client) don't support this out of the box.

If Stephan's solution uses win32com.client, chances are your with block is managing the Excel application object, not the individual workbook. That means when the with block exits, it might quit the Excel app—but only if you properly closed the workbook first. If you skip closing the workbook, Excel might hang around in the background holding onto the file.

Fix for this: #

Manually call wb.Close() inside the with block, and ensure you handle the Excel app correctly. Here's a corrected example:

import win32com.client as win32

# Use with to manage the Excel application
with win32.gencache.EnsureDispatch('Excel.Application') as excel_app:
    excel_app.Visible = False  # Set to True if you need to see the window
    # Open your workbook
    wb = excel_app.Workbooks.Open(r'C:\path\to\your\file.xlsx')
    
    # Your code to display content here (e.g., read cells)
    print("A1 cell value:", wb.Worksheets(1).Range('A1').Value)
    
    # Critical: Manually close the workbook
    # Use SaveChanges=True if you need to save edits
    wb.Close(SaveChanges=False)
# The with block will automatically quit the Excel app here

If you still see Excel running in Task Manager after this, you might need to force release COM objects (common with win32com). Add these lines after closing the workbook:

import pythoncom
pythoncom.CoUninitialize()

2. Closing files after subprocess.Popen #

When you use subprocess.Popen to open an Excel file, you're launching a separate Excel process. To close the file (and the associated process), you need to terminate that process directly.

Options to close the process: #

• Graceful termination: Use proc.terminate() to send a termination signal. This works for most cases:

  import subprocess
  
  # Launch Excel with your file
  proc = subprocess.Popen(['excel.exe', r'C:\path\to\your\file.xlsx'])
  
  # Do your work here...
  
  # Close the Excel process (and the file)
  proc.terminate()
  

• Force kill: If terminate() doesn't work (e.g., Excel is unresponsive), use proc.kill():

  proc.kill()
  

• Windows-specific taskkill: For more control (like killing child processes too), use taskkill:

  subprocess.call(['taskkill', '/F', '/T', '/PID', str(proc.pid)])
  

  • /F forces termination, /T kills child processes, /PID targets your specific process ID.

Just note: If the user has interacted with Excel (e.g., opened other files), terminating this process will close all open Excel windows tied to it. If you only want to close the specific file, you'd need to use COM automation (like the first solution) instead of subprocess.

内容的提问来源于stack exchange，提问作者A.david