一个安全彻底关闭实例Excel.Application后产生的进程方法

桃扇骨 2021-12-22 15:39 287阅读 0赞

在CSDN上看到长江支流发表这个主题，真的是很感谢！但有此细节如何没有做好还是不能释放资源，在此补充一下  
实现代码

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][] Code   
         /// <summary>  
        /// 释放Excel所占的内存。  
        /// </summary>  
        public void ReleaseComObjectExcel()  
        \{  
            if (m\_objExcel != null)  
            \{  
                m\_objExcel.UserControl = false;  
  
                //m\_objExcel.DisplayAlerts = false;  
                //m\_objExcel.Quit();  
  
                //m\_objBooks.Close();  
  
                ReleaseObj(ref m\_objFont);  
                ReleaseObj(ref m\_objRange);  
                ReleaseObj(ref m\_objSheet);  
                ReleaseObj(ref m\_objSheets);  
                ReleaseObj(ref m\_objBook);  
                ReleaseObj(ref m\_objBooks);  
                int generation = GC.GetGeneration(m\_objExcel);  
                ReleaseObj(ref m\_objExcel);  
                GC.Collect(generation);  
                m\_oMissing = null;  
            \}  
        \}  
  
        /// <summary>  
        /// 释放对象，内部调用  
        /// </summary>  
        /// <param name="o"></param>  
        private void ReleaseObj(ref object obj)  
        \{  
            if (obj != null)  
            \{  
                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);  
                obj = null;  
            \}  
        \}

最主要记住还存在引用关系的变量清除为空，这个切记

转载于:https://www.cnblogs.com/Yjianyong/archive/2009/08/06/1540685.html

[ContractedBlock.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211220/e868baef81a241fca7ae7fadf8d827ff.png