关闭Excel进程的自动化脚本-优快云博客

本文链接：https://blog.youkuaiyun.com/llxlett/article/details/8512937

本文介绍了一个用于自动关闭指定时间段内的Excel进程的代码实现，包括结束Excel进程的方法及资源清理过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/// <summary>
  /// 结束Excel进程
  /// </summary>
  public void KillExcelProcess()
  {
   Process[] myProcesses;
   DateTime startTime;
   myProcesses = Process.GetProcessesByName("Excel");

   //得不到Excel进程ID，暂时只能判断进程启动时间
   foreach(Process myProcess in myProcesses)
   {
    startTime = myProcess.StartTime;

    if(startTime > beforeTime && startTime < afterTime)
    {
     myProcess.Kill();
    }
   }
  }

  private void Dispose()
  {
   workBook.Close(null,null,null);
   app.Workbooks.Close();
   app.Quit();

   if(range != null)
   {
    System.Runtime.InteropServices.Marshal.ReleaseComObject(range);
    range = null;
   }
   if(range1 != null)
   {
    System.Runtime.InteropServices.Marshal.ReleaseComObject(range1);
    range1 = null;
   }
   if(range2 != null)
   {
    System.Runtime.InteropServices.Marshal.ReleaseComObject(range2);
    range2 = null;
   }
   if(textBox != null)
   {
    System.Runtime.InteropServices.Marshal.ReleaseComObject(textBox);
    textBox = null;
   }
   if(workSheet != null)
   {
    System.Runtime.InteropServices.Marshal.ReleaseComObject(workSheet);
    workSheet = null;
   }
   if(workBook != null)
   {
    System.Runtime.InteropServices.Marshal.ReleaseComObject(workBook);
    workBook = null;
   }
   if(app != null)
   {
    System.Runtime.InteropServices.Marshal.ReleaseComObject(app);
    app = null;
   }