C#利用com操作excel释放进程的解决方法

作者: 小雅baby
来源: 51数据库
2021-08-25

第一个

复制代码代码如下:

system.runtime.interopservices.marshal.releasecomobject(sheets);
        system.runtime.interopservices.marshal.releasecomobject(worksheet);
        system.runtime.interopservices.marshal.releasecomobject(excelapp);
        system.runtime.interopservices.marshal.releasecomobject(range);

        excelapp = null;
        wbclass = null;
        sheets = null;
        worksheet = null;
        range = null;
        gc.collect();
        gc.waitforpendingfinalizers();

释放不彻底，还是有进程存在。

第二种

复制代码代码如下:

//调用底层函数获取进程标示 
    [dllimport("user32.dll")]
    public static extern int getwindowthreadprocessid(intptr hwnd, out int processid);
    private static void killexcel(microsoft.office.interop.excel.application theapp)
    {
        int id = 0;
        intptr intptr = new intptr(theapp.hwnd);
        system.diagnostics.process p = null;
        try
        {
            getwindowthreadprocessid(intptr, out id);
            p = system.diagnostics.process.getprocessbyid(id);
            if (p != null)
            {
                p.kill();
                p.dispose();
            }
        }
        catch (exception ex)
        {

        }
    }