Excel process remains in memory after ASP.NET automation.

[Tim Marsden]

Hi,

I have a routine which is call from a ASP.NET web form. This routine creates
an excel application, opens a workbook , runs some code to update the
workbook, saves it as HTML on the sever and returns to the Web form to
display.

All is OK, except EXCEL remains in the process list in task manager.
I am following all guideline in releasing the com components.

Regards
Tim

[Curt_C [MVP]]

I'm assuming you mean its running on the server and not client?
and could you show how you release this component and call it.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Tim Marsden" <[e-mail]> wrote in message
news:u7******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

I have a routine which is call from a ASP.NET web form. This routine creates an excel application, opens a workbook , runs some code to update the
workbook, saves it as HTML on the sever and returns to the Web form to
display.

All is OK, except EXCEL remains in the process list in task manager.
I am following all guideline in releasing the com components.

Regards
Tim

[Tim Marsden]

Many thanks for reply.

Yes, you are correct it is on the server, I am aware of the licensing issues
and lack of support from Microsoft.

Code section

Dim objExcelApplica tion As Excel.Applicati on
Dim objWorkbook As Excel.Workbook
Dim objWorkbooks As Excel.Workbooks
Dim objWorksheets As Excel.Worksheet s
Dim objWorksheet As Excel.Worksheet
Dim dsExcelMenu As rdsExcelMenu

Try

Try
objExcelApplica tion = New Excel.Applicati on

objExcelApplica tion.Visible = False
objExcelApplica tion.DisplayAle rts = False

Catch ex As Exception
'>>> Excel Error
Throw ex
End Try

Try
objWorkbooks = objExcelApplica tion.Workbooks
objWorkbooks.Op en(strWorkbook, False, True)
objWorkbook = objWorkbooks.It em(1)
Catch ex As Exception
'>>> Workbook Open Error
Throw ex
End Try

** process here etc

Catch ex As Exception
Throw ex
Finally
If Not objWorksheet Is Nothing Then
ReleaseComObjec t(objWorksheet)
End If
If Not objWorksheets Is Nothing Then
ReleaseComObjec t(objWorksheets )
End If
If Not objWorkbook Is Nothing Then
objWorkbook.Clo se(False)
ReleaseComObjec t(objWorkbook)
End If
If Not objWorkbooks Is Nothing Then
ReleaseComObjec t(objWorkbooks)
End If
If Not objExcelApplica tion Is Nothing Then
objExcelApplica tion.Quit()
ReleaseComObjec t(objExcelAppli cation)
End If
GC.Collect()
GC.WaitForPendi ngFinalizers()

End Try
'============== =============== =============== =============== =====
Private Sub ReleaseComObjec t(ByRef Reference As Object)
Try
Do Until
System.Runtime. InteropServices .Marshal.Releas eComObject(Refe rence) <= 0
Loop
Catch
Finally
Reference = Nothing
GC.Collect()
End Try
End Sub
"Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
news:eP******** ******@TK2MSFTN GP10.phx.gbl...

I'm assuming you mean its running on the server and not client?
and could you show how you release this component and call it.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Tim Marsden" <[e-mail]> wrote in message
news:u7******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

I have a routine which is call from a ASP.NET web form. This routine

creates

an excel application, opens a workbook , runs some code to update the
workbook, saves it as HTML on the sever and returns to the Web form to
display.

All is OK, except EXCEL remains in the process list in task manager.
I am following all guideline in releasing the com components.

Regards
Tim

[bruce barker]

this is expected behavior. you will have to add code to kill the process if
you want it to go away.

-- bruce (sqlwork.com)
"Tim Marsden" <[e-mail]> wrote in message
news:u7******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

I have a routine which is call from a ASP.NET web form. This routine creates an excel application, opens a workbook , runs some code to update the
workbook, saves it as HTML on the sever and returns to the Web form to
display.

All is OK, except EXCEL remains in the process list in task manager.
I am following all guideline in releasing the com components.

Regards
Tim

[Rich]

I'm inclined to agree that this would be "expected" behavior - if you've paid your dues and discovered it through trial-and-error. But it seems like Tim Marsden read MS doccumentation and "expected" things to work as advertised

What you are saying makes sense. Setting the application object to nothing doesn't seem to get the job done. You have to kill the process. Got any sample code?

[Tim Marsden]

Thanks for your thoughts

I can kill a process easily, but how do I identify the Excel process which
was started by my app, and not other running Excel processes.

Tim

"Rich" <an*******@disc ussions.microso ft.com> wrote in message
news:98******** *************** ***********@mic rosoft.com...

I'm inclined to agree that this would be "expected" behavior - if you've paid your dues and discovered it through trial-and-error. But it seems like
Tim Marsden read MS doccumentation and "expected" things to work as
advertised.
What you are saying makes sense. Setting the application object to

nothing doesn't seem to get the job done. You have to kill the process.
Got any sample code?

[Steve C. Orr [MVP, MCSD]]

How many instances of Excel are you planning on having running at the same
time on your server? Hint: your server will likely choke on more than one.
You may have noticed that even a single instance of Excel runs rather
slugishly on a web server.
Read this article if you haven't already:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Tim Marsden" <[e-mail]> wrote in message
news:Om******** ******@TK2MSFTN GP11.phx.gbl...

Thanks for your thoughts

I can kill a process easily, but how do I identify the Excel process which
was started by my app, and not other running Excel processes.

Tim

"Rich" <an*******@disc ussions.microso ft.com> wrote in message
news:98******** *************** ***********@mic rosoft.com...

I'm inclined to agree that this would be "expected" behavior - if you've paid your dues and discovered it through trial-and-error. But it seems

like Tim Marsden read MS doccumentation and "expected" things to work as
advertised.

What you are saying makes sense. Setting the application object to

nothing doesn't seem to get the job done. You have to kill the process.
Got any sample code?

[Tim Marsden]

Hi

Thanks Steve, I have read your excellent article and it very enlightening

I have realised the problems with Excel.
I am now planning on moving the Excel processing one to another dedicated
machine. With queuing and first come first served type basis, I just need to
work out the mechanisms.
If anyone has ideas on how I can achieve this I would be grateful.
I have gone to far down this path to abandon the idea. (client request).
My app is primarily local excel based, however I need a way of serving over
the intranet.

Regards
Tim

"Steve C. Orr [MVP, MCSD]" <St***@Orr.ne t> wrote in message
news:uA******** ******@TK2MSFTN GP11.phx.gbl...

How many instances of Excel are you planning on having running at the same
time on your server? Hint: your server will likely choke on more than one. You may have noticed that even a single instance of Excel runs rather
slugishly on a web server.
Read this article if you haven't already:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Tim Marsden" <[e-mail]> wrote in message
news:Om******** ******@TK2MSFTN GP11.phx.gbl...

Thanks for your thoughts

I can kill a process easily, but how do I identify the Excel process which was started by my app, and not other running Excel processes.

Tim

"Rich" <an*******@disc ussions.microso ft.com> wrote in message
news:98******** *************** ***********@mic rosoft.com...

I'm inclined to agree that this would be "expected" behavior - if

you've paid your dues and discovered it through trial-and-error. But it seems

like

Tim Marsden read MS doccumentation and "expected" things to work as
advertised.

What you are saying makes sense. Setting the application object to

nothing doesn't seem to get the job done. You have to kill the process.
Got any sample code?

[Eric Marvets]

You can use System.Runtime. InteropServices .Marshal.Releas eComObject(xxx) for
each excel object that you work with, i.e. ranges, worksheets, workbooks,
and the excel app itself. After that, set each of the objects to Nothing.
When this is done, you can call GC.Collect, followed by
GC.WaitForPendi ngFinalizers().

The docs say never to call GC.Collect, but it will free the 25 MB + of
memory excel is using, so its ok. Excel was never meant to be used as a
server side app, and there are 3rd party products you can buy that will
perform better.

Hope this helps.

--
Eric Marvets
Principal Consultant

the bang project

<shameless self promotion>

Email sa*********@ban gREMOVETHISproj ect.com for Information on Our
Architecture and Mentoring Services

</shameless self promotion>

[Tim Marsden]

Thanks Eric

As your can see from my early post, I am doing the steps you recommend, but
the Excel is still resident.
I will try a different approach. Thanks for your time.

Regards
Tim
"Eric Marvets" <er*********@ba ngREMOVETHISpro ject.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

You can use System.Runtime. InteropServices .Marshal.Releas eComObject(xxx) for each excel object that you work with, i.e. ranges, worksheets, workbooks,
and the excel app itself. After that, set each of the objects to Nothing.
When this is done, you can call GC.Collect, followed by
GC.WaitForPendi ngFinalizers().

The docs say never to call GC.Collect, but it will free the 25 MB + of
memory excel is using, so its ok. Excel was never meant to be used as a
server side app, and there are 3rd party products you can buy that will
perform better.

Hope this helps.

--
Eric Marvets
Principal Consultant

the bang project

<shameless self promotion>

Email sa*********@ban gREMOVETHISproj ect.com for Information on Our
Architecture and Mentoring Services

</shameless self promotion>