I am having problem closing Excel in C#

Fahed Al Daye

I don't know what is wrong but Excel.exe remains in the task list even after I have entered this source code:

ExcelWorkBook.SaveAs(Directory.GetCurrentDirectory() + "\\deleteme.xls", misValue, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlNoChange, misValue, misValue, misValue, misValue);
            ExcelWorkBook.Close(null, null, null);
            ExcelApplication.Quit();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelWorkBooks);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelWorkSheet);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelWorkBook);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelApplication);

            GC.Collect();
            GC.WaitForPendingFinalizers();

I cannot seem to close Excel in C#. Any help would be greatly appreciate it! Thanks in advance.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Fahed Al Daye16y ago
Perfect! I love it! Just one question, how do I close it after I saved a file? This is how my program works, it saves the information in the excel file then takes it to the crystal report. But if I changed some other information and clicked preview and it saves it again on the same file it says it is already being used by another program...my question is...how do I close it all from memory so that I would be able to constantly click preview all the time without worrying about this error? Thanks in advance.
0
Roy S16y ago
I also had this problem a while ago, I solved it by using gembox spreadsheet instead of the normal excel way.

It's also a lot faster and doesn't require excel to be installed.
0
Fahed Al Daye16y ago
It is still there hangining in the windows task manager, it did not close....what to do? :(
0
Mahesh Chand16y ago
I think this guys is a spammer.
0
srinivas16y ago
Hi
before GC.Collect();
you have to make all the Excel Application objects to null.
ExcelWorkBooks=null;
ExcelWorkSheet=null;
ExcelWorkBook=null;
ExcelApplication=null;
GC.Collect();

I hope it helps you ,If yes then mark as Accepted Answer

Thank you

0
Fahed Al Daye16y ago
What does this get to do with my post?
0
Joe16y ago
.
0

I am having problem closing Excel in C#

Fahed Al Daye

16y3.8kVisual Basic .NET

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Fahed Al Daye16y ago
Perfect! I love it! Just one question, how do I close it after I saved a file? This is how my program works, it saves the information in the excel file then takes it to the crystal report. But if I changed some other information and clicked preview and it saves it again on the same file it says it is already being used by another program...my question is...how do I close it all from memory so that I would be able to constantly click preview all the time without worrying about this error? Thanks in advance.
0
Roy S16y ago
I also had this problem a while ago, I solved it by using gembox spreadsheet instead of the normal excel way.

It's also a lot faster and doesn't require excel to be installed.
0
Fahed Al Daye16y ago
It is still there hangining in the windows task manager, it did not close....what to do? :(
0
Mahesh Chand16y ago
I think this guys is a spammer.
0
srinivas16y ago
Hi
before GC.Collect();
you have to make all the Excel Application objects to null.
ExcelWorkBooks=null;
ExcelWorkSheet=null;
ExcelWorkBook=null;
ExcelApplication=null;
GC.Collect();

I hope it helps you ,If yes then mark as Accepted Answer

Thank you

0
Fahed Al Daye16y ago
What does this get to do with my post?
0
Joe16y ago
.
0