C# 关闭 Excel进程

   private bool SaveToExcel()
        {

            string FileName;
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.OverwritePrompt = true;
            saveFileDialog.AutoUpgradeEnabled = true;
            saveFileDialog.Filter = "Execl files (*.xlsx)|*.xlsx";
            saveFileDialog.FilterIndex = 1;
            saveFileDialog.Title = "保存先のファイルを選択してください";        
            Excel.Application excel = new Excel.Application();
            Excel.Workbook book = excel.Workbooks.Add(Excel.XlSheetType.xlWorksheet);
            //Excel.Sheets woSheets = book.Worksheets;
            Excel.Worksheet newSheet = null;
            Excel.Workbook ReBook = excel.Workbooks.Add(Excel.XlSheetType.xlWorksheet);

            try
            {
                //データ書き込み
                if (this.Keys.Count > 0)             
                {
                    FileName = String.Format("{0:yyyyMMdd-HHmmss}", DateTime.Now) + "-R1&R2.xls";
                    //シート追加
                    newSheet = (Excel.Worksheet)book.Sheets.Add(
                        Type.Missing, Type.Missing, this.R1sheetNo.Count + this.R2sheetNo.Count - 1, Type.Missing);
                    if (!setData(saveFileDialog, book, newSheet, this.allR1Data, this.allR2Data, this.Keys,
                        this.R1sheetNo, this.R2sheetNo, FileName,this.startLine,this.endLine))
                    {
                        return false;
                    }
                }            
                //データ書き込み
                if (this.ReKeys.Count > 0)
                {
                    FileName =  String.Format("{0:yyyyMMdd-HHmmss}", DateTime.Now) + "-R1&R2.xls";
                    //シート追加
                    newSheet = (Excel.Worksheet)ReBook.Sheets.Add(
                        Type.Missing, Type.Missing, this.ReR1sheetNo.Count + this.ReR2sheetNo.Count - 1, Type.Missing);
                    if (!setData(saveFileDialog,ReBook, newSheet, this.ReallR1Data, this.ReallR2Data, this.ReKeys,
                        this.ReR1sheetNo, this.ReR2sheetNo, FileName,this.reStartLine,this.ReEndLine))
                    {
                        return false;
                    }
                }
                
                book.Close(false);
                excel.Quit();
                return true;
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                book.Close(false);
                excel.Quit();
                if (excel != null)
                {
                    Kill(excel);
                }
                return false;
            }
            finally
            {
                if (excel != null)
                {
                    Kill(excel);
                }

            }
        }

 

        /// <summary>
        /// プロセス閉じる
        /// </summary>
        /// <param name="excelApp"></param>
        [System.Runtime.InteropServices.DllImport("User32.dll", CharSet = System.Runtime.InteropServices.CharSet.Auto)]
        public static extern int GetWindowThreadProcessId(IntPtr hwnd, out   int ID);
        private void Kill(Excel.Application excelApp)
        {
            IntPtr t = new IntPtr(excelApp.Hwnd);
            int k = 0; GetWindowThreadProcessId(t, out k);
            System.Diagnostics.Process p = System.Diagnostics.Process.GetProcessById(k);
            p.Kill();

        }

 

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值