blocks|key|56804|text|想想看，它会杀死这个过程：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|56805|System.Diagnostics.Process[]+process=System.Diagnostics.Process.GetProcessesByName("Excel");
foreach+(System.Diagnostics.Process+p+in+process)
{
++++if+(!string.IsNullOrEmpty(p.ProcessName))
++++{
++++++++try
++++++++{
++++++++++++p.Kill();
++++++++}
++++++++catch+{+}
++++}
}|code-block|syntax|javascript|56806|另外，你有没有试着正常关闭它？|56807|myWorkbook.SaveAs(@"C:/pape.xltx",+missing,+missing,+missing,+missing,+missing,+Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,+missing,+missing,+missing,+missing,+missing);
excelBook.Close(null,+null,+null);+++++++++++++++++//+close+your+workbook
excelApp.Quit();+++++++++++++++++++++++++++++++++++//+exit+excel+application
excel+=+null;++++++++++++++++++++++++++++++++++++++//+set+to+NULL|56808|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Think of this, it kills the process:

<pre><code>System.Diagnostics.Process[] process=System.Diagnostics.Process.GetProcessesByName("Excel");
foreach (System.Diagnostics.Process p in process)
{
 if (!string.IsNullOrEmpty(p.ProcessName))
 {
 try
 {
 p.Kill();
 }
 catch { }
 }
}
</code></pre>

Also, did you try just close it normally?

<pre><code>myWorkbook.SaveAs(@"C:/pape.xltx", missing, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);
excelBook.Close(null, null, null); // close your workbook
excelApp.Quit(); // exit excel application
excel = null; // set to NULL
</code></pre>

blocks|key|273407|text|excelBook.Close()；excelApp.Quit()；添加代码末尾，可能就足够了。它正在处理我的代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|273408|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

excelBook.Close();
excelApp.Quit();
add end of the code, it could be enough. it is working on my code

blocks|key|56910|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|56911|excelBook.Close(0);+
excelApp.Quit();|code-block|syntax|javascript|56912|关闭工作簿时，您有三个可选参数：|56913|Workbook.close+SaveChanges,+filename,+routeworkbook+|56914|Workbook.Close(false)，或者如果你正在做后期绑定，有时使用zero+Workbook.Close(0)会更容易，这就是我在自动关闭工作簿时所做的。|offset|length|style|CODE|56915|我还查找了它的文档，并在这里找到了它：Excel+Workbook+Close|56916|谢谢,|56917|entityMap|0|LINK|mutability|MUTABLE|url|http://office.microsoft.com/client/helppreview.aspx?AssetId=HV805549059990&lcid=1033&NS=EXCEL.DEV&Version=12&CTT=4^0|0|0|0|0|0|L|18|H|0|J|K|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|16|8|@$M|17|N|18|O|P]|$M|19|N|1A|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@$M|1C|N|1D|1|1E]]|A|$]]|$1|S|3|T|5|6|7|1F|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]]]

Try this: 

<pre><code>excelBook.Close(0); 
excelApp.Quit();
</code></pre>

When closing the work-book, you have three optional parameters:

<pre><code>Workbook.close SaveChanges, filename, routeworkbook 
</code></pre>

<code>Workbook.Close(false)</code> or if you are doing late binding, it sometimes is easier to use zero 
<code>Workbook.Close(0)</code> 
That is how I've done it when automating closing of workbooks. 

Also I went and looked up the documentation for it, and found it here:
<a href="http://office.microsoft.com/client/helppreview.aspx?AssetId=HV805549059990&amp;lcid=1033&amp;NS=EXCEL.DEV&amp;Version=12&amp;CTT=4">Excel Workbook Close</a>

Thanks,

blocks|key|56947|text|扼杀Excel并不总是那么容易；请参阅本文：50+Ways+to+Kill+Excel|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|56948|本文采纳了微软(MS+Knowlege+Base+Article)关于如何让Excel顺利退出的最佳建议，但也通过在必要时终止进程来确保这一点。我喜欢有第二个降落伞。|56949|确保关闭所有打开的工作簿，退出应用程序并释放xlApp对象。最后，检查进程是否仍在运行，如果是，则终止它。|56950|这篇文章还确保我们不会杀死所有Excel进程，而是只杀死启动的进程。|56951|另请参阅Get+Process+from+Window+Handle|56952|下面是我使用的代码：(每次都有效)|56953|Sub+UsingExcel()

++++'declare+process;+will+be+used+later+to+attach+the+Excel+process
++++Dim+XLProc+As+Process

++++'call+the+sub+that+will+do+some+work+with+Excel
++++'calling+Excel+in+a+separate+routine+will+ensure+that+it+is+
++++'out+of+scope+when+calling+GC.Collect
++++'this+works+better+especially+in+debug+mode
++++DoOfficeWork(XLProc)

++++'Do+garbage+collection+to+release+the+COM+pointers
++++'http://support.microsoft.com/kb/317109
++++GC.Collect()
++++GC.WaitForPendingFinalizers()

++++'I+prefer+to+have+two+parachutes+when+dealing+with+the+Excel+process
++++'this+is+the+last+answer+if+garbage+collection+were+to+fail
++++If+Not+XLProc+Is+Nothing+AndAlso+Not+XLProc.HasExited+Then
++++++++XLProc.Kill()
++++End+If

End+Sub

'http://msdn.microsoft.com/en-us/library/ms633522%2528v=vs.85%2529.aspx
<System.Runtime.InteropServices.DllImport("user32.dll",+SetLastError:=True)>+_
++++Private+Shared+Function+GetWindowThreadProcessId(ByVal+hWnd+As+IntPtr,+_
++++ByRef+lpdwProcessId+As+Integer)+As+Integer
End+Function

Private+Sub+ExcelWork(ByRef+XLProc+As+Process)

++++'start+the+application+using+late+binding
++++Dim+xlApp+As+Object+=+CreateObject("Excel.Application")

++++'or+use+early+binding
++++'Dim+xlApp+As+Microsoft.Office.Interop.Excel

++++'get+the+window+handle
++++Dim+xlHWND+As+Integer+=+xlApp.hwnd

++++'this+will+have+the+process+ID+after+call+to+GetWindowThreadProcessId
++++Dim+ProcIdXL+As+Integer+=+0

++++'get+the+process+ID
++++GetWindowThreadProcessId(xlHWND,+ProcIdXL)

++++'get+the+process
++++XLProc+=+Process.GetProcessById(ProcIdXL)


++++'do+some+work+with+Excel+here+using+xlApp

++++'be+sure+to+save+and+close+all+workbooks+when+done

++++'release+all+objects+used+(except+xlApp)+using+NAR(x)


++++'Quit+Excel+
++++xlApp.quit()

++++'Release
++++NAR(xlApp)

End+Sub

Private+Sub+NAR(ByVal+o+As+Object)
++++'http://support.microsoft.com/kb/317109
++++Try
++++++++While+(System.Runtime.InteropServices.Marshal.ReleaseComObject(o)+>+0)
++++++++End+While
++++Catch
++++Finally
++++++++o+=+Nothing
++++End+Try
End+Sub|code-block|syntax|javascript|56954|entityMap|0|LINK|mutability|MUTABLE|url|http://devcity.net/PrintArticle.aspx?ArticleID=239|1|http://support.microsoft.com/kb/317109|2|https://stackoverflow.com/questions/17759085/how-do-i-get-the-process-id-from-a-created-excel-application-object^0|M|L|0|0|8|O|1|0|0|0|4|U|2|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@$A|15|B|16|1|17]]|C|$]]|$1|D|3|E|5|6|7|18|8|@]|9|@$A|19|B|1A|1|1B]]|C|$]]|$1|F|3|G|5|6|7|1C|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|1D|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|1E|8|@]|9|@$A|1F|B|1G|1|1H]]|C|$]]|$1|L|3|M|5|6|7|1I|8|@]|9|@]|C|$]]|$1|N|3|O|5|P|7|1J|8|@]|9|@]|C|$Q|R]]|$1|S|3|-4|5|6|7|1K|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]|10|$5|V|W|X|C|$Y|11]]|12|$5|V|W|X|C|$Y|13]]]]

Killing Excel is not always easy; see this article: <a href="http://devcity.net/PrintArticle.aspx?ArticleID=239" rel="noreferrer">50 Ways to Kill Excel</a>

This article takes the best advice from Microsoft (<a href="http://support.microsoft.com/kb/317109" rel="noreferrer">MS Knowlege Base Article</a>) on how to get Excel to quit nicely, but then also makes sure about it by killing the process if necessary. I like having a second parachute.

Make sure to Close any open workbooks, Quit the application and Release the xlApp object. Finally check to see if the process is still alive and if so then kill it.

This article also makes sure that we don't kill all Excel processes but only kills the exact process that was started.

See also <a href="https://stackoverflow.com/questions/17759085/how-do-i-get-the-process-id-from-a-created-excel-application-object">Get Process from Window Handle</a>

Here is the code I use: (works every time)

<pre><code>Sub UsingExcel()

 'declare process; will be used later to attach the Excel process
 Dim XLProc As Process

 'call the sub that will do some work with Excel
 'calling Excel in a separate routine will ensure that it is 
 'out of scope when calling GC.Collect
 'this works better especially in debug mode
 DoOfficeWork(XLProc)

 'Do garbage collection to release the COM pointers
 'http://support.microsoft.com/kb/317109
 GC.Collect()
 GC.WaitForPendingFinalizers()

 'I prefer to have two parachutes when dealing with the Excel process
 'this is the last answer if garbage collection were to fail
 If Not XLProc Is Nothing AndAlso Not XLProc.HasExited Then
 XLProc.Kill()
 End If

End Sub

'http://msdn.microsoft.com/en-us/library/ms633522%28v=vs.85%29.aspx
&lt;System.Runtime.InteropServices.DllImport("user32.dll", SetLastError:=True)&gt; _
 Private Shared Function GetWindowThreadProcessId(ByVal hWnd As IntPtr, _
 ByRef lpdwProcessId As Integer) As Integer
End Function

Private Sub ExcelWork(ByRef XLProc As Process)

 'start the application using late binding
 Dim xlApp As Object = CreateObject("Excel.Application")

 'or use early binding
 'Dim xlApp As Microsoft.Office.Interop.Excel

 'get the window handle
 Dim xlHWND As Integer = xlApp.hwnd

 'this will have the process ID after call to GetWindowThreadProcessId
 Dim ProcIdXL As Integer = 0

 'get the process ID
 GetWindowThreadProcessId(xlHWND, ProcIdXL)

 'get the process
 XLProc = Process.GetProcessById(ProcIdXL)


 'do some work with Excel here using xlApp

 'be sure to save and close all workbooks when done

 'release all objects used (except xlApp) using NAR(x)


 'Quit Excel 
 xlApp.quit()

 'Release
 NAR(xlApp)

End Sub

Private Sub NAR(ByVal o As Object)
 'http://support.microsoft.com/kb/317109
 Try
 While (System.Runtime.InteropServices.Marshal.ReleaseComObject(o) &gt; 0)
 End While
 Catch
 Finally
 o = Nothing
 End Try
End Sub
</code></pre>

blocks|key|56990|text|xlBook.Save();
xlBook.Close(true);
xlApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|56991|试试这个..。对我来说很管用。您应该释放该xl应用程序对象以停止该进程。|unstyled|56992|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>xlBook.Save();
xlBook.Close(true);
xlApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);
</code></pre>

try this.. it worked for me...
you should release that xl application object to stop the process.

blocks|key|57023|text|+++++++++wb.Close();
+++++++++app.Quit();

+++++++++System.Diagnostics.Process[]+process+=+System.Diagnostics.Process.GetProcessesByName("Excel");
+++++++++foreach+(System.Diagnostics.Process+p+in+process)
+++++++++{
+++++++++++++if+(!string.IsNullOrEmpty(p.ProcessName)+&&+p.StartTime.AddSeconds(%2B10)+>+DateTime.Now)
+++++++++++++{
+++++++++++++++++try
+++++++++++++++++{
+++++++++++++++++++++p.Kill();
+++++++++++++++++}
+++++++++++++++++catch+{+}
+++++++++++++}
+++++++++}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|57024|它关闭名为"Excel“的最后10秒进程|unstyled|57025|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code> wb.Close();
 app.Quit();

 System.Diagnostics.Process[] process = System.Diagnostics.Process.GetProcessesByName("Excel");
 foreach (System.Diagnostics.Process p in process)
 {
 if (!string.IsNullOrEmpty(p.ProcessName) &amp;&amp; p.StartTime.AddSeconds(+10) &gt; DateTime.Now)
 {
 try
 {
 p.Kill();
 }
 catch { }
 }
 }
</code></pre>

It Closes last 10 sec process with name "Excel"

blocks|key|273603|text|++++++++GetWindowThreadProcessId((IntPtr)app.Hwnd,+out+iProcessId);
++++++++wb.Close(true,Missing.Value,Missing.Value);
++++++++app.Quit();
++++++++System.Diagnostics.Process[]+process+=+System.Diagnostics.Process.GetProcessesByName("Excel");
++++++++foreach+(System.Diagnostics.Process+p+in+process)
++++++++{
++++++++++++if+(p.Id+==+iProcessId)
++++++++++++{
++++++++++++++++try
++++++++++++++++{
++++++++++++++++++++p.Kill();
++++++++++++++++}
++++++++++++++++catch+{+}
++++++++++++}
++++++++}
}
[DllImport("user32.dll")]

private+static+extern+uint+GetWindowThreadProcessId(IntPtr+hWnd,+out+uint+lpdwProcessId);

uint+iProcessId+=+0;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|273604|此GetWindowThreadProcessId查找正确的进程Id+o+excell....杀死它之后..。好好享受吧！|unstyled|273605|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code> GetWindowThreadProcessId((IntPtr)app.Hwnd, out iProcessId);
 wb.Close(true,Missing.Value,Missing.Value);
 app.Quit();
 System.Diagnostics.Process[] process = System.Diagnostics.Process.GetProcessesByName("Excel");
 foreach (System.Diagnostics.Process p in process)
 {
 if (p.Id == iProcessId)
 {
 try
 {
 p.Kill();
 }
 catch { }
 }
 }
}
[DllImport("user32.dll")]

private static extern uint GetWindowThreadProcessId(IntPtr hWnd, out uint lpdwProcessId);

uint iProcessId = 0;
</code></pre>

this GetWindowThreadProcessId finds the correct Process Id o excell ....
After kills it....
Enjoy It!!!

blocks|key|57076|text|关闭所有excel进程的正确方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|57077|var+_excel+=+new+Application();
foreach+(Workbook+_workbook+in+_excel.Workbooks)+{
++++_workbook.Close(0);
}

_excel.Quit();
_excel+=+null;|code-block|syntax|javascript|57078|以过程为例，这可能会关闭所有的excel过程。|57079|var+process+=+System.Diagnostics.Process.GetProcessesByName("Excel");
foreach+(var+p+in+process)+{
++++if+(!string.IsNullOrEmpty(p.ProcessName))+{
++++++++try+{
++++++++++++p.Kill();
++++++++}+catch+{+}
++++}
}|57080|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The right way to close all excel process
<pre><code>var _excel = new Application();
foreach (Workbook _workbook in _excel.Workbooks) {
 _workbook.Close(0);
}

_excel.Quit();
_excel = null;
</code></pre>
Using process example, this may close all the excel process regardless.
<pre><code>var process = System.Diagnostics.Process.GetProcessesByName(&quot;Excel&quot;);
foreach (var p in process) {
 if (!string.IsNullOrEmpty(p.ProcessName)) {
 try {
 p.Kill();
 } catch { }
 }
}
</code></pre>

blocks|key|273656|text|我遇到了同样的问题，并尝试了许多方法来解决它，但都不起作用。最后，我找到了我的方式。一些参考enter+link+description+here|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|273657|希望我的代码将来能帮助到别人。我已经花了两天多的时间来解决这个问题。下面是我的代码：|273658|//get+current+in+useing+excel
++++++++++++Process[]+excelProcsOld+=+Process.GetProcessesByName("EXCEL");
++++++++++++Excel.Application+myExcelApp+=+null;
++++++++++++Excel.Workbooks+excelWorkbookTemplate+=+null;
++++++++++++Excel.Workbook+excelWorkbook+=+null;
try{
++++//DO+sth+using+myExcelApp+,+excelWorkbookTemplate,+excelWorkbook
}
catch+(Exception+ex+){
}
finally
++++++++++++{
++++++++++++++++//Compare+the+EXCEL+ID+and+Kill+it+
++++++++++++++++Process[]+excelProcsNew+=+Process.GetProcessesByName("EXCEL");
++++++++++++++++foreach+(Process+procNew+in+excelProcsNew)
++++++++++++++++{
++++++++++++++++++++int+exist+=+0;
++++++++++++++++++++foreach+(Process+procOld+in+excelProcsOld)
++++++++++++++++++++{
++++++++++++++++++++++++if+(procNew.Id+==+procOld.Id)
++++++++++++++++++++++++{
++++++++++++++++++++++++++++exist%2B%2B;
++++++++++++++++++++++++}
++++++++++++++++++++}
++++++++++++++++++++if+(exist+==+0)
++++++++++++++++++++{
++++++++++++++++++++++++procNew.Kill();
++++++++++++++++++++}++++++++
++++++++++++++++}
++++++++++++}|code-block|syntax|javascript|273659|entityMap|0|LINK|mutability|MUTABLE|url|https://www.add-in-express.com/creating-addins-blog/2013/11/05/release-excel-com-objects/^0|1A|R|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

I met the same problems and tried many methods to solve it but doesn't work.
Finally , I found the by my way. Some reference <a href="https://www.add-in-express.com/creating-addins-blog/2013/11/05/release-excel-com-objects/" rel="nofollow noreferrer">enter link description here</a>

Hope my code can help someone future. I have been spent more than two days to solve it.
Below is my Code: 

<pre><code>//get current in useing excel
 Process[] excelProcsOld = Process.GetProcessesByName("EXCEL");
 Excel.Application myExcelApp = null;
 Excel.Workbooks excelWorkbookTemplate = null;
 Excel.Workbook excelWorkbook = null;
try{
 //DO sth using myExcelApp , excelWorkbookTemplate, excelWorkbook
}
catch (Exception ex ){
}
finally
 {
 //Compare the EXCEL ID and Kill it 
 Process[] excelProcsNew = Process.GetProcessesByName("EXCEL");
 foreach (Process procNew in excelProcsNew)
 {
 int exist = 0;
 foreach (Process procOld in excelProcsOld)
 {
 if (procNew.Id == procOld.Id)
 {
 exist++;
 }
 }
 if (exist == 0)
 {
 procNew.Kill();
 } 
 }
 }
</code></pre>

blocks|key|273680|text|基于另一种解决方案。我使用了这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|273681|IntPtr+xAsIntPtr+=+new+IntPtr(excelObj.Application.Hwnd);
excelObj.ActiveWorkbook.Close();

System.Diagnostics.Process[]+process+=+System.Diagnostics.Process.GetProcessesByName("Excel");
++++++++++++++++foreach+(System.Diagnostics.Process+p+in+process)
++++++++++++++++{
++++++++++++++++++++if+(p.MainWindowHandle+==+xAsIntPtr)
++++++++++++++++++++{
++++++++++++++++++++++++try
++++++++++++++++++++++++{
++++++++++++++++++++++++++++p.Kill();
++++++++++++++++++++++++}
++++++++++++++++++++++++catch+{+}
++++++++++++++++++++}
++++++++++++++++}|code-block|syntax|javascript|273682|使用"MainWindowHandle“来识别流程并关闭流程。|273683|excelObj:这是我的应用程序互操作excel对象|273684|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Based on another solutions. I have use this:

<pre><code>IntPtr xAsIntPtr = new IntPtr(excelObj.Application.Hwnd);
excelObj.ActiveWorkbook.Close();

System.Diagnostics.Process[] process = System.Diagnostics.Process.GetProcessesByName("Excel");
 foreach (System.Diagnostics.Process p in process)
 {
 if (p.MainWindowHandle == xAsIntPtr)
 {
 try
 {
 p.Kill();
 }
 catch { }
 }
 }
</code></pre>

Using the "MainWindowHandle" to identify the process and close him.

excelObj: This is my Application Interop excel objecto

blocks|key|57195|text|您可以使用自己的COM对象excel+pid终止进程|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|57196|在dll导入代码下方添加|57197|[DllImport("user32.dll",+SetLastError+=+true)]
private+static+extern+int+GetWindowThreadProcessId(IntPtr+hwnd,+ref+int+lpdwProcessId);|code-block|syntax|javascript|57198|并使用|57199|+if+(excelApp+!=+null)
++++++++++++{
++++++++++++++++int+excelProcessId+=+-1;
++++++++++++++++GetWindowThreadProcessId(new+IntPtr(excelApp.Hwnd),+ref+excelProcessId);

++++++++++++++++Process+ExcelProc+=+Process.GetProcessById(excelProcessId);
++++++++++++++++if+(ExcelProc+!=+null)
++++++++++++++++{
++++++++++++++++++++ExcelProc.Kill();
++++++++++++++++}
++++++++++++}|57200|entityMap^0|8|3|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|R|$]]

You may kill process with your own <code>COM</code> object excel pid

add somewhere below dll import code

<pre><code>[DllImport("user32.dll", SetLastError = true)]
private static extern int GetWindowThreadProcessId(IntPtr hwnd, ref int lpdwProcessId);
</code></pre>

and use

<pre><code> if (excelApp != null)
 {
 int excelProcessId = -1;
 GetWindowThreadProcessId(new IntPtr(excelApp.Hwnd), ref excelProcessId);

 Process ExcelProc = Process.GetProcessById(excelProcessId);
 if (ExcelProc != null)
 {
 ExcelProc.Kill();
 }
 }
</code></pre>

blocks|key|57236|text|为每个Excel对象使用一个变量，并且必须循环Marshal.ReleaseComObject+>0。如果没有循环，Excel进程仍保持活动状态。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|57237|public+class+test{
++++++++private+dynamic+ExcelObject;
++++++++protected+dynamic+ExcelBook;
++++++++protected+dynamic+ExcelBooks;
++++++++protected+dynamic+ExcelSheet;

public+void+LoadExcel(string+FileName)
++++++++{
++++++++++++Type+t+=+Type.GetTypeFromProgID("Excel.Application");
++++++++++++if+(t+==+null)+throw+new+Exception("Excel+non+installato");
++++++++++++ExcelObject+=+System.Activator.CreateInstance(t);
++++++++++++ExcelObject.Visible+=+false;
++++++++++++ExcelObject.DisplayAlerts+=+false;
++++++++++++ExcelObject.AskToUpdateLinks+=+false;
++++++++++++ExcelBooks+=+ExcelObject.Workbooks;
++++++++++++ExcelBook+=+ExcelBooks.Open(FileName,0,true);
++++++++++++System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");
++++++++++++ExcelSheet+=+ExcelBook.Sheets[1];
++++++++}
+private+void+ReleaseObj(object+obj)
++++++++{
++++++++++++try
++++++++++++{
++++++++++++++++int+i+=+0;
+++++++++++++while(+++System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)+>+0)
++++++++++++++++{
++++++++++++++++++++i%2B%2B;
++++++++++++++++++++if+(i+>+1000)+break;
++++++++++++++++}
++++++++++++++++obj+=+null;
++++++++++++}
++++++++++++catch+
++++++++++++{
++++++++++++++++obj+=+null;
++++++++++++}
++++++++++++finally
++++++++++++{
++++++++++++++++GC.Collect();
++++++++++++}
++++++++}
++++++++public+void+ChiudiExcel()+{
++++++++++++System.Threading.Thread.CurrentThread.CurrentCulture+=+ci;

++++++++++++ReleaseObj(ExcelSheet);
++++++++++++try+{+ExcelBook.Close();+}+catch+{+}
++++++++++++try+{+ExcelBooks.Close();+}+catch+{+}
++++++++++++ReleaseObj(ExcelBooks);
++++++++++++try+{+ExcelObject.Quit();+}+catch+{+}
++++++++++++ReleaseObj(ExcelObject);
++++++++}
}|code-block|syntax|javascript|57238|entityMap^0|N|R|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Use a variable for each Excel object and must loop <code>Marshal.ReleaseComObject &gt;0</code>. Without the loop, Excel process still remain active.

<pre><code>public class test{
 private dynamic ExcelObject;
 protected dynamic ExcelBook;
 protected dynamic ExcelBooks;
 protected dynamic ExcelSheet;

public void LoadExcel(string FileName)
 {
 Type t = Type.GetTypeFromProgID("Excel.Application");
 if (t == null) throw new Exception("Excel non installato");
 ExcelObject = System.Activator.CreateInstance(t);
 ExcelObject.Visible = false;
 ExcelObject.DisplayAlerts = false;
 ExcelObject.AskToUpdateLinks = false;
 ExcelBooks = ExcelObject.Workbooks;
 ExcelBook = ExcelBooks.Open(FileName,0,true);
 System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");
 ExcelSheet = ExcelBook.Sheets[1];
 }
 private void ReleaseObj(object obj)
 {
 try
 {
 int i = 0;
 while( System.Runtime.InteropServices.Marshal.ReleaseComObject(obj) &gt; 0)
 {
 i++;
 if (i &gt; 1000) break;
 }
 obj = null;
 }
 catch 
 {
 obj = null;
 }
 finally
 {
 GC.Collect();
 }
 }
 public void ChiudiExcel() {
 System.Threading.Thread.CurrentThread.CurrentCulture = ci;

 ReleaseObj(ExcelSheet);
 try { ExcelBook.Close(); } catch { }
 try { ExcelBooks.Close(); } catch { }
 ReleaseObj(ExcelBooks);
 try { ExcelObject.Quit(); } catch { }
 ReleaseObj(ExcelObject);
 }
}
</code></pre>

blocks|key|273815|text|我们可以使用以下代码在将xls转换为xlsx时关闭Excel应用程序。当我们执行这类任务时，当Excel应用程序在任务管理器中运行时，我们应该关闭这个后台运行的excel。Interop是一个Com组件，我们使用Marshal.FinalReleaseComObject来发布com组件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|273816|+private+void+button1_Click(object+sender,+EventArgs+e)
++++{

++++++++Excel03to07("D:\\TestExls\\TestExcelApp.XLS");

++++}
++++private+void+Excel03to07(string+fileName)
++++{
++++++++string+svfileName+=+Path.ChangeExtension(fileName,+".xlsx");
++++++++object+oMissing+=+Type.Missing;
++++++++var+app+=+new+Microsoft.Office.Interop.Excel.Application();
++++++++var+wb+=+app.Workbooks.Open(fileName,+oMissing,+oMissing,
++++++++++++++++++++++++oMissing,+oMissing,+oMissing,+oMissing,+oMissing,+oMissing,+oMissing,+oMissing,+oMissing,+oMissing,+oMissing,+oMissing);
++++++++wb.SaveAs(svfileName,+XlFileFormat.xlOpenXMLWorkbook,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+XlSaveAsAccessMode.xlNoChange,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing);

++++++++wb.Close(false,+Type.Missing,+Type.Missing);
++++++++app.Quit();
++++++++GC.Collect();
++++++++Marshal.FinalReleaseComObject(wb);
++++++++Marshal.FinalReleaseComObject(app);
+++}|code-block|syntax|javascript|273817|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

We can close the Excel Application while converting xls to xlsx by using following code.
When we perform this kind of task then Excel application is running in task manager, we Should close this excel which is running in background. Interop is a Com component ,to release the com component we used Marshal.FinalReleaseComObject.

<pre><code> private void button1_Click(object sender, EventArgs e)
 {

 Excel03to07("D:\\TestExls\\TestExcelApp.XLS");

 }
 private void Excel03to07(string fileName)
 {
 string svfileName = Path.ChangeExtension(fileName, ".xlsx");
 object oMissing = Type.Missing;
 var app = new Microsoft.Office.Interop.Excel.Application();
 var wb = app.Workbooks.Open(fileName, oMissing, oMissing,
 oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
 wb.SaveAs(svfileName, XlFileFormat.xlOpenXMLWorkbook, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

 wb.Close(false, Type.Missing, Type.Missing);
 app.Quit();
 GC.Collect();
 Marshal.FinalReleaseComObject(wb);
 Marshal.FinalReleaseComObject(app);
 }
</code></pre>

blocks|key|273867|text|大多数方法都是有效的，但excel过程会一直持续到应用程序关闭。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|273868|当终止一次excel进程时，它不能在同一线程中再次执行-不知道为什么。|273869|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Most of the methods works, but the excel process always stay until close the appliation.

When kill excel process once it can't be executed once again in the same thread - don't know why.

blocks|key|273871|text|private+void+releaseObject(object+obj)
{
++++try
++++{
++++++++System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
++++++++obj+=+null;
++++}
++++catch+(Exception+ex)
++++{
++++++++obj+=+null;
++++++++MessageBox.Show("Unable+to+release+the+Object+"+%2B+ex.ToString());
++++}
++++finally
++++{
++++++++GC.Collect();
++++}
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|273872|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>private void releaseObject(object obj)
{
 try
 {
 System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
 obj = null;
 }
 catch (Exception ex)
 {
 obj = null;
 MessageBox.Show("Unable to release the Object " + ex.ToString());
 }
 finally
 {
 GC.Collect();
 }
}
</code></pre>

blocks|key|273887|text|workbook.Close(0);
excelApp.Quit();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|273888|对我很管用。|unstyled|273889|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>workbook.Close(0);
excelApp.Quit();
</code></pre>
Worked for me.

blocks|key|57397|text|此问题的另一个解决方案是保存您正在使用的Excel程序的ProcessID。然后，当您完成该程序时，您可以特定地终止该Excel进程，而不以其他excel进程为目标。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|57398|我从this+answer得到了解决方案。我想我会在这里分享它|offset|length|57399|因此，首先，将这些代码行添加到类方法之外|57400|//+The+DllImport+requires+--+Using+System.Runtime.InteropServices;
[DllImport("user32.dll",+SetLastError+=+true)]
private+static+extern+int+GetWindowThreadProcessId(IntPtr+hwnd,+ref+int+lpdwProcessId);|code-block|syntax|javascript|57401|在那之后,|57402|现在，在您选择的方法中，添加这些行。这些行将丢弃您正在使用的特定excel过程。|57403|根据您的需要修改它们，但逻辑是相同的|57404|++++++++if+(ExcelApp+!=+null)
++++++++{
++++++++++++int+excelProcessId+=+0;

++++++++++++//your+Excel+Application+variable+has+access+to+its+Hwnd+property
++++++++++++GetWindowThreadProcessId(new+IntPtr(ExcelApp.Hwnd),+ref+excelProcessId);

++++++++++++//+you+need+System.Diagnostics+to+use+Process+Class
++++++++++++Process+ExcelProc+=+Process.GetProcessById(excelProcessId);

++++++++++++if+(ExcelProc+!=+null)
++++++++++++{
++++++++++++++++ExcelProc.Kill();
++++++++++++}
++++++++}|57405|57406|因此，总的来说，您的程序应该如下所示|57407|class+Program
{
++++[DllImport("user32.dll",+SetLastError+=+true)]
++++private+static+extern+int+GetWindowThreadProcessId(IntPtr+hwnd,+ref+int+lpdwProcessId);

++++static+void+Main(string[]+args)
++++{
++++++++Application+ExcelApp+=+new+Application();

++++++++_Workbook+ExcelWrkBook+=+ExcelApp.Workbooks.Open(filePath);

++++++++_Worksheet+ExcelWrkSht+=+ExcelWrkBook.ActiveSheet;

++++++++ExcelWrkSht.Cells[1,+2]+=+"70";

++++++++if+(ExcelApp+!=+null)
++++++++{
++++++++++++int+excelProcessId+=+0;+//+simple+declare,+zero+is+merely+a+place+holder

++++++++++++GetWindowThreadProcessId(new+IntPtr(ExcelApp.Hwnd),+ref+excelProcessId);

++++++++++++Process+ExcelProc+=+Process.GetProcessById(excelProcessId);

++++++++++++if+(ExcelProc+!=+null)
++++++++++++{
++++++++++++++++ExcelProc.Kill();
++++++++++++}
++++++++}

++++}
}|57408|我已经测试过了，它删除了我的Excel进程，如任务管理器中所示|57409|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/13242462/7082154^0|0|2|4|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@]|9|@$D|1B|E|1C|1|1D]]|A|$]]|$1|F|3|G|5|6|7|1E|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|1F|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1G|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1I|8|@]|9|@]|A|$]]|$1|S|3|T|5|J|7|1J|8|@]|9|@]|A|$K|L]]|$1|U|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1L|8|@]|9|@]|A|$]]|$1|X|3|Y|5|J|7|1M|8|@]|9|@]|A|$K|L]]|$1|Z|3|10|5|6|7|1N|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]]|12|$13|$5|14|15|16|A|$17|18]]]]

Another solution to this problem is to save the ProcessID of the Excel program in which you are working with. Then when you are done with the program, you can specifially kill that Excel process without targeting other excel processes.
I got the solution from <a href="https://stackoverflow.com/a/13242462/7082154">this</a> answer. Thought I would share it here
So first, you add these line of code outside of a class method
<pre><code>// The DllImport requires -- Using System.Runtime.InteropServices;
[DllImport(&quot;user32.dll&quot;, SetLastError = true)]
private static extern int GetWindowThreadProcessId(IntPtr hwnd, ref int lpdwProcessId);
</code></pre>
After that,
Now in a method of your choosing, add these lines.
These lines discard the specific excel process that you are working with
Modify them to your needs, but the logic is thesame
<pre><code> if (ExcelApp != null)
 {
 int excelProcessId = 0;

 //your Excel Application variable has access to its Hwnd property
 GetWindowThreadProcessId(new IntPtr(ExcelApp.Hwnd), ref excelProcessId);

 // you need System.Diagnostics to use Process Class
 Process ExcelProc = Process.GetProcessById(excelProcessId);

 if (ExcelProc != null)
 {
 ExcelProc.Kill();
 }
 }
</code></pre>
<hr />
Hence in total your program should look like this
<pre><code>class Program
{
 [DllImport(&quot;user32.dll&quot;, SetLastError = true)]
 private static extern int GetWindowThreadProcessId(IntPtr hwnd, ref int lpdwProcessId);

 static void Main(string[] args)
 {
 Application ExcelApp = new Application();

 _Workbook ExcelWrkBook = ExcelApp.Workbooks.Open(filePath);

 _Worksheet ExcelWrkSht = ExcelWrkBook.ActiveSheet;

 ExcelWrkSht.Cells[1, 2] = &quot;70&quot;;

 if (ExcelApp != null)
 {
 int excelProcessId = 0; // simple declare, zero is merely a place holder

 GetWindowThreadProcessId(new IntPtr(ExcelApp.Hwnd), ref excelProcessId);

 Process ExcelProc = Process.GetProcessById(excelProcessId);

 if (ExcelProc != null)
 {
 ExcelProc.Kill();
 }
 }

 }
}
</code></pre>
I have tested this and it removes my Excel processes as shown in Task Manager

I'm writing an application in C# that opens an Excel template file for read/write operations. I want to when user closes the application, excel application process has been closed, without saving excel file. See my Task Manager after multiple runs of the app.

<img src="https://i.stack.imgur.com/87zea.jpg" alt="enter image description here">

I use this code to open the excel file :

<pre><code>public Excel.Application excelApp = new Excel.Application();
public Excel.Workbook excelBook;
excelBook = excelApp.Workbooks.Add(@"C:/pape.xltx");
</code></pre>

and for data access I use this code :

<pre><code>Excel.Worksheet excelSheet = (Worksheet)(excelBook.Worksheets[1]);
excelSheet.DisplayRightToLeft = true;
Range rng;
rng = excelSheet.get_Range("C2");
rng.Value2 = txtName.Text;
</code></pre>

I see similar questions in stackoverflow such as <a href="https://stackoverflow.com/questions/12530303/close-excel-application-process-after-data-has-been-fetched">this question</a> and <a href="https://stackoverflow.com/questions/15255065/interop-excel-not-closing-process">this</a>, and test answers, but it doesn't works.

Closing Excel Application Process in C# after Data Access

我正在用C#编写一个应用程序，它打开一个用于读/写操作的Excel模板文件。我想当用户关闭应用程序时，excel应用程序进程已经关闭，不保存excel文件。在多次运行应用程序后，请查看我的任务管理器。​​我使用以下代码打开excel文件：public Excel.Application excelApp = new E...

问数据访问后关闭C#中的Excel应用程序进程
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数据访问后关闭C#中的Excel应用程序进程EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数据访问后关闭C#中的Excel应用程序进程
EN