Databases
StackOverflow2013
Postsdbo
POC# Proper Way to Close Multiple Excel Objects With Excel Process Destroyed
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POC# Proper Way to Close Multiple Excel Objects With Excel Process Destroyed
    primarykey
    data
    text
    <p>I have a C# console program. When it runs, it instantiates some Excel objects such as: (openExcelO). </p> <p>When the program is done running, I have a method to close down Excel (closeExcel) and that is supposed to properly clean up the Excel process. In task manager I can see the remnants of Excel that remain. The shut down routines were cobbled together from internet examples:</p> <pre><code> private void openExcelO (string dir) { try { xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(dir + "PortfolioOptimization5.xlsm", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); xlMarkowitz = (Excel.Worksheet)xlWorkBook.Sheets["Markowitz"]; xlWeights = (Excel.Worksheet)xlWorkBook.Sheets["Weights"]; } catch (Exception ex) { ReportError("PortfolioOptimization", "openExcel", ex.ToString()); } } private void closeExcel () { object misValue = System.Reflection.Missing.Value; try { if (xlWeights != null) releaseObject(xlWeights); if (xlMarkowitz != null) releaseObject(xlMarkowitz); xlWorkBook.Close(false, misValue, misValue); if (xlApp != null) xlApp.Quit(); if (xlWorkBook != null) releaseObject(xlWorkBook); if (xlApp != null) releaseObject(xlApp); } catch (Exception ex) { ReportError("PortfolioOptimization", "closeExcel", ex.ToString()); } } private void releaseObject (object obj) { try { System.Runtime.InteropServices.Marshal.ReleaseComObject(obj); obj = null; } catch (Exception ex) { obj = null; ReportError("PortfolioOptimization", "releaseObject", "Unable to release object " + ex.ToString()); } finally { GC.Collect(); } } </code></pre> <p>How can I change the shutdown routine to properly shut down and clean up the Excel objects so there are no lingering Excel processes in the Task Manager?</p> <p>Thanks!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USPatrick White
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POC# Proper Way to Close Multiple Excel Objects With Excel Process Destroyed
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POC# Proper Way to Close Multiple Excel Objects With Excel Process Destroyed
      1. USRAS
      1. VTFavorite
    3. VO
      singulars
      1. POC# Proper Way to Close Multiple Excel Objects With Excel Process Destroyed
      1. This table or related slice is empty.
      1. VTDownMod
    1. COYou should probably try releasing the workbook immediately after you close it, _then_ close excel, _then_ release the application. Does `Quit` have a boolean overload to allow exit while ignoring all errors? The Word interop object does.
      singulars
      1. POC# Proper Way to Close Multiple Excel Objects With Excel Process Destroyed
      1. USSimon MᶜKenzie
    2. COpossible duplicate of [Proper way of closing Excel application](http://stackoverflow.com/questions/9581689/proper-way-of-closing-excel-application)
      singulars
      1. POC# Proper Way to Close Multiple Excel Objects With Excel Process Destroyed
      1. USKen White
    3. CONote also that in addition to the fact that you should always [think very hard before invoking `GC.Collect`](http://stackoverflow.com/a/118776/622391), your calls to `GC.Collect` won't actually help your object get collected, as your main class still holds a reference to each of your COM objects. To make `releaseObject` also clear the primary reference, change it to `releaseObject(ref object obj)`, because then when you invoke `obj = null`, the field itself will be set to null.
      singulars
      1. POC# Proper Way to Close Multiple Excel Objects With Excel Process Destroyed
      1. USSimon MᶜKenzie
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload