Closing Excel Application Process in C# after Data Access

by

Try this:

excelBook.Close(0); 
excelApp.Quit();

When closing the work-book, you have three optional parameters:

Workbook.close SaveChanges, filename, routeworkbook

Workbook.Close(false) or if you are doing late binding, it sometimes is easier to use zero
Workbook.Close(0)
That is how I’ve done it when automating closing of workbooks.

Also I went and looked up the documentation for it, and found it here:
Excel Workbook Close

More Related Contents:

  1. Fastest method to remove Empty rows and Columns From Excel Files using Interop
  2. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  3. Microsoft Office Excel cannot access the file ‘c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx’
  4. How to reference Microsoft.Office.Interop.Excel dll?
  5. Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
  6. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  7. Optimal way to Read an Excel file (.xls/.xlsx)
  8. Moq & Interop Types: works in VS2012, fails in VS2010?
  9. Accessing an open Excel Workbook in C#
  10. How to convert a column number (e.g. 127) into an Excel column (e.g. AA)
  11. How to read data of an Excel file using C#?
  12. Kill process tree programmatically in C#
  13. A Simple C# DLL – how do I call it from Excel, Access, VBA, VB6?
  14. How to get the range of occupied cells in excel sheet
  15. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  16. What is the algorithm to convert an Excel Column Letter into its Number?
  17. How to use use late binding to get excel instance?
  18. Cell color changing in Excel using C#
  19. How to turn off brackets/quotes auto-completion in Visual Studio
  20. C# – How to copy a single Excel worksheet from one workbook to another?
  21. Please explain why I am able to instantiate the “Application” interface in Excel VSTO
  22. Can the Visual Studio Debugger display strings unquoted/unescaped?
  23. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  24. Query excel sheet in c#
  25. using statement FileStream and / or StreamReader – Visual Studio 2012 Warnings
  26. openxml spreadsheat save-as
  27. Printing Excel using Interop
  28. Scientific notation when importing from Excel in .Net
  29. As of today, what is the right way to work with COM objects? [duplicate]
  30. Import Excel to Datagridview

Leave a Comment