Click here to Skip to main content
15,879,844 members
Home / Discussions / C#
   

C#

 
GeneralRe: Open new tab that not exist Pin
tamir90112-Aug-09 5:08
tamir90112-Aug-09 5:08 
GeneralRe: Open new tab that not exist Pin
Moreno Airoldi12-Aug-09 6:56
Moreno Airoldi12-Aug-09 6:56 
GeneralRe: Open new tab that not exist Pin
tamir90112-Aug-09 18:54
tamir90112-Aug-09 18:54 
GeneralRe: Open new tab that not exist Pin
Moreno Airoldi13-Aug-09 0:31
Moreno Airoldi13-Aug-09 0:31 
QuestionProblem to Export DataTable to Excel. Pin
hdv2127-Aug-09 1:10
hdv2127-Aug-09 1:10 
AnswerRe: Problem to Export DataTable to Excel. Pin
Tamer Oz7-Aug-09 1:37
Tamer Oz7-Aug-09 1:37 
GeneralRe: Problem to Export DataTable to Excel. Pin
hdv2127-Aug-09 2:28
hdv2127-Aug-09 2:28 
Questionwhen is Excel shutdown completed? Pin
Harry6667-Aug-09 1:07
Harry6667-Aug-09 1:07 
Hello there,

I wrote a tool for importing and exporting data into ExcelSheets (better said: workbooks).

Some relevant parts of my code are:
using Excel = Microsoft.Office.Interop.Excel;
Excel.ApplicationClass excelApp = new Excel.ApplicationClass();
excelApp.ScreenUpdating = false;
excelApp.DisplayAlerts = false;

then I open some workbooks, open some sheets, write some stuff into them and close all of them. I also dereference them if they are no more needed (mysheet = null).
But after finally shutting down the ExcelApp doing so:
excelApp.Quit();
excelApp = null;

... I have to wait quite a long time (about half a minute) until I see the EXCEL-thread diappear in my ProcessExplorer.
The problem is, that I can not open the just written xls-files if the application did not end, because it still has got its hands on the files.
So I have to know when this happens.

My questions are:
Why does it take so long?
When does the Excel-thread really end?
How do I end it correctly?
How can I provoke the thread to be ended?
Or is it just a matter of garbage collection? (a field I did not yet explore)

Thanks in advance,
Harry

no plan,
no signature

AnswerRe: when is Excel shutdown completed? Pin
Moreno Airoldi7-Aug-09 2:03
Moreno Airoldi7-Aug-09 2:03 
QuestionRe: when is Excel shutdown completed? Pin
Harry6667-Aug-09 5:06
Harry6667-Aug-09 5:06 
AnswerRe: when is Excel shutdown completed? Pin
Moreno Airoldi7-Aug-09 15:12
Moreno Airoldi7-Aug-09 15:12 
GeneralRe: when is Excel shutdown completed? Pin
Harry66610-Aug-09 23:29
Harry66610-Aug-09 23:29 
GeneralRe: when is Excel shutdown completed? Pin
Moreno Airoldi11-Aug-09 0:10
Moreno Airoldi11-Aug-09 0:10 
GeneralRe: when is Excel shutdown completed? Pin
Harry66611-Aug-09 3:20
Harry66611-Aug-09 3:20 
GeneralRe: when is Excel shutdown completed? Pin
Moreno Airoldi12-Aug-09 1:24
Moreno Airoldi12-Aug-09 1:24 
GeneralRe: when is Excel shutdown completed? Pin
Harry66612-Aug-09 2:09
Harry66612-Aug-09 2:09 
GeneralRe: when is Excel shutdown completed? Pin
Moreno Airoldi12-Aug-09 2:15
Moreno Airoldi12-Aug-09 2:15 
AnswerRe: when is Excel shutdown completed? Pin
Luc Pattyn7-Aug-09 5:31
sitebuilderLuc Pattyn7-Aug-09 5:31 
GeneralRe: when is Excel shutdown completed? Pin
Harry6668-Aug-09 1:38
Harry6668-Aug-09 1:38 
GeneralRe: when is Excel shutdown completed? Pin
Luc Pattyn8-Aug-09 1:47
sitebuilderLuc Pattyn8-Aug-09 1:47 
GeneralRe: when is Excel shutdown completed? Pin
Harry6668-Aug-09 2:22
Harry6668-Aug-09 2:22 
GeneralRe: when is Excel shutdown completed? Pin
Moreno Airoldi11-Aug-09 0:11
Moreno Airoldi11-Aug-09 0:11 
QuestionActive Crystal Report Pin
sharad Pyakurel7-Aug-09 0:45
sharad Pyakurel7-Aug-09 0:45 
QuestionCommunicating with another form... Pin
Baeltazor7-Aug-09 0:39
Baeltazor7-Aug-09 0:39 
AnswerRe: Communicating with another form... Pin
MarkB7777-Aug-09 0:44
MarkB7777-Aug-09 0:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.