Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?

by

Got it!

application.Workbooks != application.Workbooks

This property doesn’t expose a variable, it generates a value. So every time I access the Workbooks property I create a new COM object.

I fixed the code and all is well. Thanks, everybody.

var excelApplication = new Application();
var workbooks = excelApplication.Workbooks;
var workbook = workbooks.Open(pathToExcelWorkbook); // Fixed

workbook.Close();
workbooks.Close();
excelApplication.Quit();

Marshal.ReleaseComObject(workbook);
Marshal.ReleaseComObject(workbooks);
Marshal.ReleaseComObject(excelApplication);

More Related Contents:

  1. Accessing an open Excel Workbook in C#
  2. Reading Datetime value From Excel sheet
  3. Fastest method to remove Empty rows and Columns From Excel Files using Interop
  4. Closing Excel Application Process in C# after Data Access
  5. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  6. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  7. Microsoft Office Excel cannot access the file ‘c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx’
  8. Get instance of Excel application with C# by Handle
  9. The quest for the Excel custom function tooltip
  10. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  11. How to make correct date format when writing data to Excel
  12. Importing Excel into a DataTable Quickly
  13. How to save workbook without showing save dialog with Excel interop?
  14. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  15. Optimal way to Read an Excel file (.xls/.xlsx)
  16. C# – How to add an Excel Worksheet programmatically – Office XP / 2003
  17. Reading Excel files from C#
  18. How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
  19. Format an Excel column (or cell) as Text in C#?
  20. Exception from HRESULT: 0x800A03EC Error
  21. How to write some data to excel file(.xlsx)
  22. How to export a JQgrid data to Excel using c#?
  23. Accessing Office Word object model through asp.net results in “failed due to the following error: 80070005 Access is denied.”
  24. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  25. What reference do I need to use Microsoft.Office.Interop.Excel in .NET?
  26. How to know if a cell has an error in the formula in C#
  27. how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
  28. Using ExcelDataReader to read Excel data starting from a particular cell
  29. EPPlus – LoadFromCollection – Text converted to number
  30. .Net Excel Interop Deleting a worksheet

Leave a Comment