怎么关闭Excel进程

[telankes2000]

private IntPtr GetProcessHandle
    {
        get { return (IntPtr)ViewState["ProcessHandle"]; }
        set { ViewState["ProcessHandle"] = value; }
    }

    private int GetProcessID
    {
        get { return (int)ViewState["ProcessID"]; }
        set { ViewState["ProcessID"] = value; }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        Process process = Process.GetCurrentProcess();
        process.StartInfo.FileName = Server.MapPath("wahaha/mp932.xls");
        process.StartInfo.UseShellExecute = false;
        process.Start();//当打开的Excel大于1个时 就报错 不是有效的win32程序
        GetProcessHandle = process.Handle;
        GetProcessID = process.Id;
    }
    private void KillPreocess(int processID)
    {
        Process p = Process.GetProcessById(processID);
        p.Kill();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        KillPreocess(GetProcessID);
    }

问题是只能在打开一个Excel的情况下关闭进程

[柳晛]

finally
{
workBooks.Close();
if (xlsApp != null)
{
xlsApp.Workbooks.Close();
xlsApp.Quit();

int gc = GC.GetGeneration(xlsApp);
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlsApp);
xlsApp = null;

GC.Collect(gc);
}
GC.Collect();
}

[柳晛]

            finally
            {
                workBooks.Close();
                if (xlsApp != null)
                {
                    xlsApp.Workbooks.Close();
                    xlsApp.Quit();

                    int gc = GC.GetGeneration(xlsApp);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(xlsApp);
                    xlsApp = null;

                    GC.Collect(gc);
                }
                GC.Collect();
            }

[wjq]

若若的问你一下……你在ASP.NET服务端打开Excel文档有啥用……？最终用户又不能操作……

[gwf25sz]

-0-

Ctrl + Alt + Delete

进去找到了就能关了哈

^_^

是不是感觉被我当作白痴了???? 嘿嘿

[telankes2000]

是导出Excel 目的是导出之后关闭Excel进程

[wosizy]

用过NPOI没 这东西可以自懂关闭进程

[wjq]

导出excel貌似不应该用process来做吧。要么用COM要么用OLEDB。COM的话，释放掉所有资源后，应该可以关掉Excel进程。但往往也不work，折中办法记录下启动com组件的时间和结束时间。结束后在改时间段内启动的excel进程都杀掉。