Query: Closing and Killing the Excel.exe from the processor
Hi,
i've developed a web application to retrieve the data from Sqlserver 2000 and fill it in the Dataset then, using
the dataset i'l write the data into the Excel template file by opening the Excel and copying the excel sheet
writing the data into it. After writing the data i'l save the template file as a new file with different name. then
i'm closing the Excel books, sheets and quits the excel application.
My problem is after closing and quiting the Excel application also the Excel.exe is still running idle in the
processor, so i can't open the excel file. Only After killing the Excel.exe only i'm able to open the saved Excel
File.
In my application multiple user can access the same application so multiple Excel.exe will be running in the
process. How to find out my Excel.exe and kill it.
Here is my code:
using System;
using Excel;
using System.IO;
using System.Net;
using System.Collections;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Diagnostics;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Runtime.InteropServices;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using RealImageReports.Reports;
using RealImageReports.Include;
namespace RealImageReports
{
public class ExcelWriter
{
Excel.ApplicationClass _excel = new Excel.ApplicationClass();
Excel.Workbooks oBooks;
Excel._Workbook oBook;
Excel.Worksheet ws;
public void WorkSheetOpen(string path, string filename)
{
oBooks = _excel.Workbooks;
oBook = oBooks.Open(path + filename, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing );
_excel.Visible = true;
}
public void WriteData(string path, string filename, DataSet _ds, string theatre, string Ads, string
STime, string ETime)
{
ws =(Worksheet) oBook.Worksheets[1];
ws.Activate();
ws.Copy(ws, Type.Missing);
ws.Name = theatre;
ws=(Worksheet) oBook.Worksheets[theatre];
ws.Activate();
FillHeadersParam(theatre, Ads, STime, ETime);
FillDataRows(ws, _ds);
}
public void FillHeadersParam(string theatre, string Ads, string STime, string ETime)
{
AddItemToSpreadsheet(5, 2, ws, theatre);
AddItemToSpreadsheet(5, 6, ws, STime);
AddItemToSpreadsheet(6, 2, ws, Ads);
AddItemToSpreadsheet(6, 6, ws, ETime);
AutoFitColumn(ws, 2);
AutoFitColumn(ws, 5);
}
public void WorkSheetClose()
{
ws =oBook.Sheets.get_Item(1) as Excel.Worksheet;
ws.Activate();
ws.Visible = Excel.XlSheetVisibility.xlSheetVeryHidden;
oBook.Save();
oBook.Close(XlSaveAction.xlSaveChanges,Type.Missing, Type.Missing);
oBooks.Close();
oBooks.Application.Quit();
_excel.Quit();
Marshal.ReleaseComObject(ws);
Marshal.ReleaseComObject(oBook);
Marshal.ReleaseComObject(oBooks);
Marshal.ReleaseComObject(_excel);
}
}
}
keenly waiting for your reply.
Regards,
Selvaraj.A