By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,573 Members | 3,008 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,573 IT Pros & Developers. It's quick & easy.

how to kill EXCEL component in taskManager which is in memory

P: n/a
hi,
I am generating excel reports through vb.Net. After creating
excel.application and the report is generated, each report leaves Excel in
memory. I can see them in task manager in Process tab (as EXCEL). So the
memory has been taken by excel objects and memory is being full. i want to
delete or kill this objects which are in memory. i wrote the code as
'myexcel.quit()' , myexcel=nothing. but still it is in memory.
pls tell me how to do.
rgds,
Hari.
Nov 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
It's not really a great idea to use Excel from ASP.NET. Excel just wasn't
designed for such a task, and that's why you are experiencing flakey
behavior.
Here's some best practices on the subject of exporting to Excel from
ASP.NET:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"hari krishna" <ha*********@discussions.microsoft.com> wrote in message
news:35**********************************@microsof t.com...
hi,
I am generating excel reports through vb.Net. After creating
excel.application and the report is generated, each report leaves Excel in
memory. I can see them in task manager in Process tab (as EXCEL). So the
memory has been taken by excel objects and memory is being full. i want to
delete or kill this objects which are in memory. i wrote the code as
'myexcel.quit()' , myexcel=nothing. but still it is in memory.
pls tell me how to do.
rgds,
Hari.

Nov 18 '05 #2

P: n/a
hi hari,
Check this article it might be useful to u
http://www.codeproject.com/aspnet/wordapplication.asp
the best
srini

"hari krishna" wrote:
hi,


Nov 18 '05 #3

P: n/a
hi Steve,
Thank you very much for the answer.
I have read the examples on the aspnetpro.com page and tried the first two
examples through ASP.Net.
for the second example whose heading is 'Simply Compatible: Tab Delimited
Format'.
The code executed successfully but it didnot generate any xl file.
In the code for response.addheader i gave the file name with path though it
did not generate xl file.
Response.AddHeader("Content-Disposition", "inline;filename=c:\testHKVG.xls")
The code for above is like this below:
'------------------------------------------------------------
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
Dim scon As SqlConnection = New SqlConnection("server=10.109.30.102;
UID=vf99; Pwd=lamap; database=dev;") ' Trusted_Connection=No")
scon.Open()
Dim adapter As SqlDataAdapter
Dim dt As DataTable
Dim ds As DataSet

adapter = New SqlDataAdapter("select * from tb_vf_property", scon)
ds = New DataSet
adapter.Fill(ds, "dt")
dt = ds.Tables("dt")
''Dim dt1 As DataTable
''dt1 = dt
''dt1 = CType(Application.Item("dt"), dt)

Response.ContentType = "application/ms-excel"
Response.AddHeader("Content-Disposition",
"inline;filename=c:\testHKVG.xls")

Response.Write(ConvertDtToTDF(dt))
End Sub

'Converts a DataTable to Tab Delimited Format
Private Function ConvertDtToTDF(ByVal dt As DataTable) As String
Dim dr As DataRow, ary() As Object, i As Integer
Dim iCol As Integer

'Output Column Headers
For iCol = 0 To dt.Columns.Count - 1
Response.Write(dt.Columns(iCol).ToString & vbTab)
Next
Response.Write(vbCrLf)

'Output Data
For Each dr In dt.Rows
ary = dr.ItemArray
For i = 0 To UBound(ary)
Response.Write(ary(i).ToString & vbTab)
Next
Response.Write(vbCrLf)
Next
End Function
''---------------------------------------------------------
for 1st example whose heading is 'Make Excel Do the Work',
i got the below error at the line: Dim oExcel As New Excel.Application() in
aspx form.
pls suggest me how to solve it.

Access is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access is denied.

ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET write access to a file, right-click the file in Explorer,
choose "Properties" and select the Security tab. Click "Add" to add the
appropriate user or group. Highlight the ASP.NET account, and check the boxes
for the desired access.

Source Error:
Line 28: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Line 29:
Line 30: Dim oExcel As Excel.Application = New Excel.Application
Line 31:
Line 32: Dim oBooks As Excel.Workbooks, oBook As Excel.Workbook
Source File: E:\Inetpub\wwwroot\WebApplication1\WebForm3.aspx.v b Line: 30

Stack Trace:
[UnauthorizedAccessException: Access is denied.]
WebApplication1.WebForm3.Page_Load(Object sender, EventArgs e) in
E:\Inetpub\wwwroot\WebApplication1\WebForm3.aspx.v b:30
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()


"Steve C. Orr [MVP, MCSD]" wrote:
It's not really a great idea to use Excel from ASP.NET. Excel just wasn't
designed for such a task, and that's why you are experiencing flakey
behavior.
Here's some best practices on the subject of exporting to Excel from
ASP.NET:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"hari krishna" <ha*********@discussions.microsoft.com> wrote in message
news:35**********************************@microsof t.com...
hi,
I am generating excel reports through vb.Net. After creating
excel.application and the report is generated, each report leaves Excel in
memory. I can see them in task manager in Process tab (as EXCEL). So the
memory has been taken by excel objects and memory is being full. i want to
delete or kill this objects which are in memory. i wrote the code as
'myexcel.quit()' , myexcel=nothing. but still it is in memory.
pls tell me how to do.
rgds,
Hari.


Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.