Problem with process Excel

[siedem]

Hi

I have very strange problem with excel process. (C#, Win 2k, Office 2002)
I can open application process:
m_objExcel = new Application();

Later i'm working with this, write some data from sql2000 to cells and try
to close excel. Everything seems to be ok but process doesn't end. What's
interesting if i have for exeample small quantity of data (single table)
process end. But if i have more tables - it doesn't. Are there any timeouts
or any tricks to do it?

m_objBook.SaveAs(filePath, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt,
XlSaveAsAccessMode.xlNoChange, m_objOpt, m_objOpt, m_objOpt, m_objOpt,
m_objOpt);

m_objBook.Close(false, m_objOpt, m_objOpt);

m_objExcel.Quit();

System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheets);

System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBook);

System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBooks);

System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objExcel);

//Clean-up

m_objFont=null;

m_objRange = null;

m_objSheet = null;

m_objSheets = null;

m_objBooks = null;

m_objBook = null;

m_objExcel = null;

GC.Collect();

GC.WaitForPendingFinalizers();



thanks in advance

P.

 

[Patrick Molloy]

you need to be sure that all all references to the excel
app have been properly terminated
eg is WS is a worksheet object that had been set to a
sheet, then
SET WS = NOTHING
and so on

Patrick Molloy
Microsoft Excel MVP

 

[siedem]

ok, i have done it
problem was very strange
when i moved my function to new class created specially for generating
report everything works fine

 

[aletikreddy]

hi,

I am also using the same kind of application and getting the sam
problem, Excel.exe is remaning in the task manager, if i run th
application for 10 times, 10 excel.exe 's r staying in the tas
manager, how to remove them from task manager, because it is slowin
down the performance of my web server.

thanks

Alet