Ufdjrw

word describing multiple paths to the same abstract outcome

Is the next prime number always the next number divisible by the current prime number, except for any numbers previously divisible by primes?

Visiting the UK as unmarried couple

I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?

Would it be legal for a US State to ban exports of a natural resource?

What (else) happened July 1st 1858 in London?

Simple image editor tool to draw a simple box/rectangle in an existing image

Adding empty element to declared container without declaring type of element

Bob has never been a M before

Is it possible to build a CPA Secure encryption scheme which remains secure even when the encryption of secret key is given?

What do you call the infoboxes with text and sometimes images on the side of a page we find in textbooks?

Simple recursive Sudoku solver

Is exact Kanji stroke length important?

What is Sitecore Managed Cloud?

Resetting two CD4017 counters simultaneously, only one resets

Is there enough fresh water in the world to eradicate the drinking water crisis?

Is it okay / does it make sense for another player to join a running game of Munchkin?

Can a Gentile theist be saved?

Can I create an upright 7-foot × 5-foot wall with the Minor Illusion spell?

How to prevent YouTube from showing already watched videos?

Can I rely on these GitHub repository files?

Meta programming: Declare a new struct on the fly

Is there any significance to the Valyrian Stone vault door of Qarth?

Organic chemistry Iodoform Reaction

I am facing with the following error in Windows Form Application ? Can anyone help to resolve it

Cross-thread operation not valid: Control accessed from a thread other than the thread it was created onHow do I properly clean up Excel interop objects?Best practice to save application settings in a Windows Forms ApplicationDDE Server Window - Application ErrorAdd leading zeroes/0's to existing Excel values to certain lengthIs it possible to force Excel recognize UTF-8 CSV files automatically?How to implement the following as in the image using asp.net c# GridViewHttpClient.GetAsync(…) never returns when using await/asyncImport image from Excel sheet into SQL Server table C#Why not inherit from List<T>?

1

After uploading the data from excel and storing it in gridview , and closing the applicatoion, the following pop-up appears after all the task is been performed.enter image description here

Have written the code for excel wokbook and excel sheet to close
i.e: sWorkbook.Close();
sExcelApp.Quit();

c# .net excel windows forms

share|improve this question

asked Mar 7 at 10:16

Hetaxi PatelHetaxi Patel

71

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please show us all of your code that is related to using anything from the Excel object model.
  
  – Enigmativity
  Mar 7 at 11:49
  

  
  
  
  

add a comment | 

1

After uploading the data from excel and storing it in gridview , and closing the applicatoion, the following pop-up appears after all the task is been performed.enter image description here

Have written the code for excel wokbook and excel sheet to close
i.e: sWorkbook.Close();
sExcelApp.Quit();

c# .net excel windows forms

share|improve this question

asked Mar 7 at 10:16

Hetaxi PatelHetaxi Patel

71

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please show us all of your code that is related to using anything from the Excel object model.
  
  – Enigmativity
  Mar 7 at 11:49
  

  
  
  
  

add a comment | 

After uploading the data from excel and storing it in gridview , and closing the applicatoion, the following pop-up appears after all the task is been performed.enter image description here

Have written the code for excel wokbook and excel sheet to close
i.e: sWorkbook.Close();
sExcelApp.Quit();

c# .net excel windows forms

share|improve this question

asked Mar 7 at 10:16

Hetaxi PatelHetaxi Patel

71

share|improve this question

asked Mar 7 at 10:16

Hetaxi PatelHetaxi Patel

71

share|improve this question

asked Mar 7 at 10:16

Hetaxi PatelHetaxi Patel

71

asked Mar 7 at 10:16

Hetaxi PatelHetaxi Patel

71

asked Mar 7 at 10:16

Hetaxi PatelHetaxi Patel

71

1 Answer
1

active

oldest

votes

0

Above message is due to your excel object is not getting closed it still remain in system process.

You can actually release your Excel Application object cleanly, but you do have to take care.
COM object you access and then explicitly release it via Marshal.FinalReleaseComObject() is correct in theory, but, unfortunately, very difficult to manage in practice.

// Cleanup
GC.Collect();
GC.WaitForPendingFinalizers();

Marshal.FinalReleaseComObject(xlRng);
Marshal.FinalReleaseComObject(xlSheet);

xlBook.Close(Type.Missing, Type.Missing, Type.Missing);
Marshal.FinalReleaseComObject(xlBook);

xlApp.Quit();

Marshal.FinalReleaseComObject(xlApp);
In most code examples you'll see for cleaning up COM objects from .NET, the GC.Collect() and GC.WaitForPendingFinalizers() calls are made TWICE as in:

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

share|improve this answer

answered Mar 7 at 10:33

Tanmay NeheteTanmay Nehete

1,45121730

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55041262%2fi-am-facing-with-the-following-error-in-windows-form-application-can-anyone-he%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Above message is due to your excel object is not getting closed it still remain in system process.

You can actually release your Excel Application object cleanly, but you do have to take care.
COM object you access and then explicitly release it via Marshal.FinalReleaseComObject() is correct in theory, but, unfortunately, very difficult to manage in practice.

// Cleanup
GC.Collect();
GC.WaitForPendingFinalizers();

Marshal.FinalReleaseComObject(xlRng);
Marshal.FinalReleaseComObject(xlSheet);

xlBook.Close(Type.Missing, Type.Missing, Type.Missing);
Marshal.FinalReleaseComObject(xlBook);

xlApp.Quit();

Marshal.FinalReleaseComObject(xlApp);
In most code examples you'll see for cleaning up COM objects from .NET, the GC.Collect() and GC.WaitForPendingFinalizers() calls are made TWICE as in:

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

share|improve this answer

answered Mar 7 at 10:33

Tanmay NeheteTanmay Nehete

1,45121730

add a comment | 

0

Above message is due to your excel object is not getting closed it still remain in system process.

You can actually release your Excel Application object cleanly, but you do have to take care.
COM object you access and then explicitly release it via Marshal.FinalReleaseComObject() is correct in theory, but, unfortunately, very difficult to manage in practice.

// Cleanup
GC.Collect();
GC.WaitForPendingFinalizers();

Marshal.FinalReleaseComObject(xlRng);
Marshal.FinalReleaseComObject(xlSheet);

xlBook.Close(Type.Missing, Type.Missing, Type.Missing);
Marshal.FinalReleaseComObject(xlBook);

xlApp.Quit();

Marshal.FinalReleaseComObject(xlApp);
In most code examples you'll see for cleaning up COM objects from .NET, the GC.Collect() and GC.WaitForPendingFinalizers() calls are made TWICE as in:

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

share|improve this answer

answered Mar 7 at 10:33

Tanmay NeheteTanmay Nehete

1,45121730

add a comment | 

Above message is due to your excel object is not getting closed it still remain in system process.

You can actually release your Excel Application object cleanly, but you do have to take care.
COM object you access and then explicitly release it via Marshal.FinalReleaseComObject() is correct in theory, but, unfortunately, very difficult to manage in practice.

// Cleanup
GC.Collect();
GC.WaitForPendingFinalizers();

Marshal.FinalReleaseComObject(xlRng);
Marshal.FinalReleaseComObject(xlSheet);

xlBook.Close(Type.Missing, Type.Missing, Type.Missing);
Marshal.FinalReleaseComObject(xlBook);

xlApp.Quit();

Marshal.FinalReleaseComObject(xlApp);
In most code examples you'll see for cleaning up COM objects from .NET, the GC.Collect() and GC.WaitForPendingFinalizers() calls are made TWICE as in:

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

share|improve this answer

answered Mar 7 at 10:33

Tanmay NeheteTanmay Nehete

1,45121730

// Cleanup
GC.Collect();
GC.WaitForPendingFinalizers();

Marshal.FinalReleaseComObject(xlRng);
Marshal.FinalReleaseComObject(xlSheet);

xlBook.Close(Type.Missing, Type.Missing, Type.Missing);
Marshal.FinalReleaseComObject(xlBook);

xlApp.Quit();

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

share|improve this answer

answered Mar 7 at 10:33

Tanmay NeheteTanmay Nehete

1,45121730

answered Mar 7 at 10:33

Tanmay NeheteTanmay Nehete

1,45121730

answered Mar 7 at 10:33

Tanmay NeheteTanmay Nehete

1,45121730