终止Excel进程

using System.Web; using Excel; using System.Threading; using System.IO; using System.Diagnostics; namespace KillExcelProcess { public class KillExcelProcess { private DateTime beforeStartingExcel;//Excel启动之前时间 private DateTime afterStartingExcel;//Excel启动之后时间 Excel.Application sampleExcelApplication; Excel.Workbook sampleWorkbook; Excel.Worksheet sampleWorksheet; Excel.Range sampleCellRange; Excel.TextBox sampleSheetBox; public KillExcelProcess( string templetPath ) { sampleExcelApplication = new Excel.Application( ); beforeStartingExcel = DateTime.Now; sampleExcelApplication = new Excel.Application( ); sampleExcelApplication.Visible = true; afterStartingExcel = DateTime.Now; sampleWorkbook = sampleExcelApplication.Workbooks.Open( templetPath , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing ); sampleWorksheet = (Excel.Worksheet)sampleWorkbook.Worksheets.get_Item( 2 ); //使用第二个Worksheet } public void ExcelMethod( ) { try { sampleCellRange = sampleWorksheet.get_Range( "B5" , "C7" ); sampleCellRange.Merge( Excel.XlAxisCrosses.xlAxisCrossesAutomatic ); sampleCellRange.Value2 = "Excel2003"; sampleCellRange = sampleWorksheet.get_Range( "D8" , "E11" ); sampleCellRange.MergeCells = true; sampleCellRange.Value2 = "Excel2003"; sampleCellRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter; sampleCellRange.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; sampleCellRange = sampleWorksheet.get_Range( "A1" , Type.Missing ); sampleCellRange.Value2 = 5; sampleCellRange = sampleWorksheet.get_Range( "A2" , Type.Missing ); sampleCellRange.Value2 = 7; for( int i = 1 ; i < 100 ; i++ ) { string s = string.Concat( "G" , i.ToString( ) ); sampleCellRange = sampleWorksheet.get_Range( s , Type.Missing ); sampleCellRange.Value2 = i.ToString( ); } } catch { //这里用Dispose()方法结束不了Excel进程，所以还是要用Process的Kill()方法配合使用 this.KillExcel( ); } } /// <summary> /// 另存为Excel文件 /// </summary> /// <param name="savePath">保存路径</param> public void SaveAsExcelFile( string savePath ) { sampleWorkbook.SaveAs( savePath , Excel.XlFileFormat.xlHtml , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Excel.XlSaveAsAccessMode.xlExclusive , Type.Missing , Type.Missing , Type.Missing , Type.Missing , Type.Missing ); } /// <summary> /// 结束Excel进程 /// </summary> public void KillExcel( ) { Process[ ] myProcesses; DateTime startTime; myProcesses = Process.GetProcessesByName( "Excel" ); //得不到Excel进程ID，暂时只能判断进程启动时间 foreach( Process myProcess in myProcesses ) { startTime = myProcess.StartTime; if( startTime > beforeStartingExcel && startTime < afterStartingExcel ) { myProcess.Kill( ); } } } /// <summary> /// 如果对Excel的操作没有引发异常的话，用这个方法可以正常结束Excel进程 /// 否则要用KillExcel()方法来结束Excel进程 /// </summary> public void Dispose( ) { //注意：这里用到的所有Excel对象都要执行ReleaseComObject,否则结束不了Excel进程 sampleWorkbook.Close( null , null , null ); sampleExcelApplication.Workbooks.Close( ); sampleExcelApplication.Quit( ); if( sampleCellRange != null ) { System.Runtime.InteropServices.Marshal.ReleaseComObject( sampleCellRange ); sampleCellRange = null; } if( sampleSheetBox != null ) { System.Runtime.InteropServices.Marshal.ReleaseComObject( sampleSheetBox ); sampleSheetBox = null; } if( sampleWorksheet != null ) { System.Runtime.InteropServices.Marshal.ReleaseComObject( sampleWorksheet ); sampleWorksheet = null; } if( sampleWorkbook != null ) { System.Runtime.InteropServices.Marshal.ReleaseComObject( sampleWorkbook ); sampleWorkbook = null; } if( sampleExcelApplication != null ) { System.Runtime.InteropServices.Marshal.ReleaseComObject( sampleExcelApplication ); sampleExcelApplication = null; } GC.Collect( ); GC.WaitForPendingFinalizers( ); } } }

       这段代码能很好的解决Excel进程不能正常结束的问题，如果主机操作系统不是服务器版的话，那么就要借助于ntsd -c q -p pid命令来结束。
        还有一个问题的关于Excel组件访问权限的配置，一定要在组件服务里面正确配置，否则结束不了Excel进程，具体的配置方法在我项目的doc文件夹下；在我前面的文章里面介绍了在web.config文件里面加入假扮用户的方法，但是经我测试发现这种方法虽然可以访问Excel组件，但是结束不了进程，除非用Kill方法强行结束。

Excel组件在Windows 2003 Server环境下的配置文档

 

1、  在开始菜单-〉运行键入“dcomcnfg” 进入组件服务控制台，如图：

2.在控制台树型菜单“组件服务-〉计算机-〉我的电脑-〉DCOM配置”下找到Microsoft Excel

应用程序,如

3.点击右键，打开Excel 应用程序属性页，转到“安全”选项，如下图：

4.将启动权限、访问权限和配置权限都设置为自定义，然后依次点编辑按钮来配置自定义权限，添加“Network 
   Service”用户，将该用户的权限都设置为允许，如下图