Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Housekpng w/ Excel

Reply
Thread Tools

Housekpng w/ Excel

 
 
nikedog@msu.edu
Guest
Posts: n/a
 
      11-05-2003
I realize that xl won't scale; this is only to import
legacy data into sql server.

My problem is that Excel stays resident in memory after
the following code.

I've tried many combinations but everything leaves Excel
(running under the ASPNET user) as a process running

Any advice suggestions, please.


Imports System.Runtime.InteropServices.Marshal


Dim oXL As Excel.Application
Dim oWorkbook As Excel.Workbook
Dim oWorksheet As Excel.Worksheet

oXL = New Excel.Application
oXL.Visible = False
oXL.Workbooks.Open(sFid)
oWorkbook = oXL.ActiveWorkbook

' Process reading xl file only here

oXL.Quit()
ReleaseComObject(oWorksheet)
ReleaseComObject(oWorkbook)
ReleaseComObject(oXL)
oWorksheet = Nothing
oWorkbook = Nothing
oXL = Nothing
System.GC.Collect()

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to return an excel file or excel data from ASP.NET Anonieko ASP .Net 2 02-12-2008 07:03 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
using Microsoft Excel image for Export to Excel button =?Utf-8?B?U3JpZGhhcg==?= ASP .Net 0 12-09-2005 08:58 PM
exporting an excel file from database; making changes to excel file and updating the database by importing it back Luis Esteban Valencia ASP .Net 1 01-12-2005 12:28 AM
Excel _WorkBook vs. Excel.Workbook =?Utf-8?B?SmltIEhlYXZleQ==?= ASP .Net 1 09-29-2004 03:48 PM



Advertisments