Velocity Reviews - Computer Hardware Reviews

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

Thread Tools

Housekpng w/ Excel
Posts: n/a
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
oWorkbook = oXL.ActiveWorkbook

' Process reading xl file only here

oWorksheet = Nothing
oWorkbook = Nothing
oXL = Nothing

Reply With Quote

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