asp.net產生xls檔案完成後自動關閉excel進程代碼

來源:互聯網
上載者:User

asp教程.net產生xls檔案完成後自動關閉excel進程代碼
//方法一

gc.collect();
        applicationclass excel;
        _workbook xbk;
        _worksheet xst;
        excel = new applicationclass();
        xbk = excel.workbooks.add(true);
        xst = (_worksheet)xbk.activesheet;
           //自訂代碼...
        //結束時
        xbk.close(false, null, null);
        excel.quit();
        system.runtime.interops教程ervices.marshal.releasecomobject(xbk);
        system.runtime.interopservices.marshal.releasecomobject(excel);
        system.runtime.interopservices.marshal.releasecomobject(xst);
        xbk = null;
        excel = null;
        xst = null;

//方法二

 

finally
            {
                ((microexcel._application)tempapp).workbooks.close();
                int32 tempgeneration = gc.getgeneration(tempapp);
                ((microexcel._application)tempapp).quit();
                gc.collect(tempgeneration);
                //上面部分在winform中就已經幹掉excel進程了,但是在asp.net教程中還不行          
                process[] myprocesses;
                myprocesses = process.getprocessesbyname("excel");

                //得不到excel進程id,暫時只能判斷進程啟動時間
                foreach (process myprocess in myprocesses)
                {
                    try
                    {
                        datetime starttime = myprocess.starttime;

                        if (starttime >= tempstart && starttime <= tempend)
                        {
                            myprocess.kill();
                        }
                    }//直接在vs中運行網頁就不會有取不到starttime的問題
                    catch//有一些核心進程是不允許訪問的,因此而引起的異常可以捕獲並放棄處理
                    { }
                }
                    
            }

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.