A COM Interop Question
-
Look at the following code
Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application(); ... ExcelApp.Quit();The Excel object is not release after 'Quit()' method(Excel is still in the background process list).I think it is because there is still a reference of the object. I a windows application,this will be solved when I close the application. But I'm using these code in an asp.net application.Every time they execute,the background process list grows. Is there any way to relase the object or Is there any code to read excel files without using Microsoft Excel? -
Look at the following code
Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application(); ... ExcelApp.Quit();The Excel object is not release after 'Quit()' method(Excel is still in the background process list).I think it is because there is still a reference of the object. I a windows application,this will be solved when I close the application. But I'm using these code in an asp.net application.Every time they execute,the background process list grows. Is there any way to relase the object or Is there any code to read excel files without using Microsoft Excel?Did you invoke Close method of Workbook before call Quit() ? Following links might help Why Excel doesn't close?[^] Excel won't quit page[^]
Sohail Please mark helpful answers