COM Question (Excel)

[Gunawan]

Dear All,

I have create an excel (COM Object) using this code

Excel.Applicati on xls = new Excel.Applicati on();

but I can not remove it from memory although I have using close and quit

wb.Close(false, false, 0);
xls.Quit();
If I open task manager there is excel.exe. If I run multiple time the number
of excel.exe in task manager will increase.

Please Help.

Regards,
Gunawan

[Patrick Steele]

In article <uB************ **@TK2MSFTNGP06 .phx.gbl>,
jg**********@gm ail.com says...

Dear All,

I have create an excel (COM Object) using this code

Excel.Applicati on xls = new Excel.Applicati on();

but I can not remove it from memory although I have using close and quit

wb.Close(false, false, 0);
xls.Quit();
If I open task manager there is excel.exe. If I run multiple time the number
of excel.exe in task manager will increase.

What is "wb"? A reference to a workbook I assume?

Make sure you release every COM object you get a reference to using
Marshal.Release ComObject()

Excel.Applicati on xls = new Excel.Applicati on();
try
{
wb = ...
try
{
...
}
finally
{
wb.Close(false, false, 0);
Marshal.Release ComObject(wb);
}
}
finally
{
xls.Quit();
Marshal.Release ComObject(xls);
}

--
Patrick Steele
http://weblogs.asp.net/psteele

[Gunawan]

Hi Patrick,
I still can not release excel.exe from the memory.

Currenty I am using this code on *.aspx file to response click button.

Is it related to this issue? and I am using visual studio 2003.
Marshal.Release ComObject still can not remove excel.exe. :(
Regards,
Gunawan
"Patrick Steele" <pa*****@mvps.o rgwrote in message
news:MP******** *************** *@msnews.micros oft.com...

In article <uB************ **@TK2MSFTNGP06 .phx.gbl>,
jg**********@gm ail.com says...

>Dear All,

I have create an excel (COM Object) using this code

Excel.Applicat ion xls = new Excel.Applicati on();

but I can not remove it from memory although I have using close and quit

wb.Close(false , false, 0);
xls.Quit();
If I open task manager there is excel.exe. If I run multiple time the
number
of excel.exe in task manager will increase.

What is "wb"? A reference to a workbook I assume?

Make sure you release every COM object you get a reference to using
Marshal.Release ComObject()

Excel.Applicati on xls = new Excel.Applicati on();
try
{
wb = ...
try
{
...
}
finally
{
wb.Close(false, false, 0);
Marshal.Release ComObject(wb);
}
}
finally
{
xls.Quit();
Marshal.Release ComObject(xls);
}

--
Patrick Steele
http://weblogs.asp.net/psteele

[RobinS]

It's more likely that whatever you are doing in Excel is leaving something
open. Are you doing OLE Automation or what? This is a problem *many* people
have when doing OLE Automation with Excel.

For example, I had a problem once and it turned out to be a problem with
Ranges. If you use any kind of Ranges (like
..range(.cells( 1,2),.cells(3,4 )).merge=true), Excel creates a Range object
behind the scenes, and does not dispose of it. You have to do this:

(Sorry this is VB)

Dim myRange as Range = xlsheet.range(. Cells(1,2),.cel ls(3,4))
myRange.Merge=T rue
myRange = Nothing

That's just one example, but it depends on what you're doing. The way I
tracked it down was I commented out every single excel command I was using,
then uncommented them one at a time until I found the culprit. Tedious, but
effective.

So the question is, what are you doing with Excel? Are you just opening it
and closing it, or are you doing something in-between?

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
-----------------------------------------------
"Gunawan" <jg**********@g mail.comwrote in message
news:uw******** *****@TK2MSFTNG P06.phx.gbl...

Hi Patrick,
I still can not release excel.exe from the memory.

Currenty I am using this code on *.aspx file to response click button.

Is it related to this issue? and I am using visual studio 2003.
Marshal.Release ComObject still can not remove excel.exe. :(
Regards,
Gunawan
"Patrick Steele" <pa*****@mvps.o rgwrote in message
news:MP******** *************** *@msnews.micros oft.com...

>In article <uB************ **@TK2MSFTNGP06 .phx.gbl>,
jg**********@gm ail.com says...

>>Dear All,

I have create an excel (COM Object) using this code

Excel.Applica tion xls = new Excel.Applicati on();

but I can not remove it from memory although I have using close and
quit

wb.Close(fals e, false, 0);
xls.Quit();
If I open task manager there is excel.exe. If I run multiple time the
number
of excel.exe in task manager will increase.

What is "wb"? A reference to a workbook I assume?

Make sure you release every COM object you get a reference to using
Marshal.Releas eComObject()

Excel.Applicat ion xls = new Excel.Applicati on();
try
{
wb = ...
try
{
...
}
finally
{
wb.Close(false , false, 0);
Marshal.Releas eComObject(wb);
}
}
finally
{
xls.Quit();
Marshal.Releas eComObject(xls) ;
}

--
Patrick Steele
http://weblogs.asp.net/psteele

[Gunawan]

I will try to explain what I am doing with excel file.

I try to open excel file
Open Excel file
---------------
Application xls = new Application();
_Workbook wb = xls.Workbooks.O pen(strFilename ,
0, true, 5, "", "", true, Excel.XlPlatfor m.xlWindows,
"\t", false, false, 0 , true, 0, 0);

_Worksheet wsh = (_Worksheet) wb.Worksheets[1];

Retrieving Data
for
{

strKodeBarang = ((Range) wsh.Cells[i,1]).Value2.ToStri ng() ;
strNamaBarang = ((Range) wsh.Cells[i,2]).Value2.ToStri ng() ;
}
Releasing Object
-----------------
Marshal.Release ComObject(wsh);

wb.Close(false, false, 0);
Marshal.Release ComObject(wb);

xls.Quit();
Marshal.Release ComObject(xls);
I use this tehnique using vb6 and no excel.exe retain on memory.
But using C# always left excel.exe in memory.

Regards,
Gun

"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:HO******** *************** *******@comcast .com...

It's more likely that whatever you are doing in Excel is leaving something
open. Are you doing OLE Automation or what? This is a problem *many*
people have when doing OLE Automation with Excel.

For example, I had a problem once and it turned out to be a problem with
Ranges. If you use any kind of Ranges (like
.range(.cells(1 ,2),.cells(3,4) ).merge=true), Excel creates a Range object
behind the scenes, and does not dispose of it. You have to do this:

(Sorry this is VB)

Dim myRange as Range = xlsheet.range(. Cells(1,2),.cel ls(3,4))
myRange.Merge=T rue
myRange = Nothing

That's just one example, but it depends on what you're doing. The way I
tracked it down was I commented out every single excel command I was
using, then uncommented them one at a time until I found the culprit.
Tedious, but effective.

So the question is, what are you doing with Excel? Are you just opening it
and closing it, or are you doing something in-between?

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
-----------------------------------------------
"Gunawan" <jg**********@g mail.comwrote in message
news:uw******** *****@TK2MSFTNG P06.phx.gbl...

>Hi Patrick,
I still can not release excel.exe from the memory.

Currenty I am using this code on *.aspx file to response click button.

Is it related to this issue? and I am using visual studio 2003.
Marshal.Releas eComObject still can not remove excel.exe. :(
Regards,
Gunawan
"Patrick Steele" <pa*****@mvps.o rgwrote in message
news:MP******* *************** **@msnews.micro soft.com...

>>In article <uB************ **@TK2MSFTNGP06 .phx.gbl>,
jg**********@gm ail.com says...
Dear All,

I have create an excel (COM Object) using this code

Excel.Applic ation xls = new Excel.Applicati on();

but I can not remove it from memory although I have using close and
quit

wb.Close(fal se, false, 0);
xls.Quit() ;
If I open task manager there is excel.exe. If I run multiple time the
number
of excel.exe in task manager will increase.

What is "wb"? A reference to a workbook I assume?

Make sure you release every COM object you get a reference to using
Marshal.Relea seComObject()

Excel.Applica tion xls = new Excel.Applicati on();
try
{
wb = ...
try
{
...
}
finally
{
wb.Close(fals e, false, 0);
Marshal.Relea seComObject(wb) ;
}
}
finally
{
xls.Quit();
Marshal.Relea seComObject(xls );
}

--
Patrick Steele
http://weblogs.asp.net/psteele

[Laurent Bugnion [MVP]]

Hi,

Gunawan wrote:

Hi Patrick,
I still can not release excel.exe from the memory.

Currenty I am using this code on *.aspx file to response click button.

That's quite a bad idea, regardless of all the other problems you're
getting:

http://support.microsoft.com/default...US;q257757#kb2

There are other ways to deal with Excel on the server. Using ADO.NET ist
a good way, or you can also manipulate Excel files in XML format.

HTH,
Laurent
--
Laurent Bugnion [MVP ASP.NET]
Software engineering: http://www.galasoft-LB.ch
PhotoAlbum: http://www.galasoft-LB.ch/pictures
Support children in Calcutta: http://www.calcutta-espoir.ch

[Willy Denoyette [MVP]]

"Gunawan" <jg**********@g mail.comwrote in message
news:eZ******** ******@TK2MSFTN GP03.phx.gbl...

>I will try to explain what I am doing with excel file.

I try to open excel file
Open Excel file
---------------
Application xls = new Application();
_Workbook wb = xls.Workbooks.O pen(strFilename ,
0, true, 5, "", "", true, Excel.XlPlatfor m.xlWindows,
"\t", false, false, 0 , true, 0, 0);

_Worksheet wsh = (_Worksheet) wb.Worksheets[1];

Retrieving Data
for
{

strKodeBarang = ((Range) wsh.Cells[i,1]).Value2.ToStri ng() ;
strNamaBarang = ((Range) wsh.Cells[i,2]).Value2.ToStri ng() ;
}
Releasing Object
-----------------
Marshal.Release ComObject(wsh);

wb.Close(false, false, 0);
Marshal.Release ComObject(wb);

Should be...
xls.Quit();
GC.Collect();
GC.WaitForPendi ngFinalizers();

Anyway, you should know that this is an unsupported scenario for Office application,
especially in .NET as you can never rely on the Finalizer to release all outstanding COM
references.

http://support.microsoft.com/kb/257757

Willy.