Office PIA：注意Office App进程的管理

在Office PIA应用程序中，对Office App的管理不容忽视。

在正常情况下，程序launch office app以后，通过interop的COM组件进行文档操作，然后保存、关闭office app。但这个过程在出错的情况下，office app可能还没有关闭，并且依然占用着所操作的文件，这当然不是我们期望看到的。

以ExcelApp这个类为例，看看我在里面是怎么考虑的。以下贴出一些相关的程序片断：

    using System;
    using System.Collections.Generic;
    using System.Diagnostics;
    using System.Globalization;
    using System.IO;
    using System.Threading;
    using Excel = Microsoft.Office.Interop.Excel;

    /// <summary>
    /// Excel application interop class.
    /// </summary>
    public class ExcelApp : IDisposable
    {
        #region Const definition
        /// <summary>Microsoft Excel application process name.</summary>
        private const string ExcelProcessName = "EXCEL";
        #endregion

        #region Private variables
        /// <summary>Original Excel Application processes before launching new Excel process.</summary>
        private Process[] originalExcelProcess = null;
        #endregion

        #region Initializations and Finalizations
        /// <summary>
        /// Initializes a new instance of the ExcelApp class.
        /// </summary>
        public ExcelApp()
        {
            // ......

            this.originalExcelProcess = Process.GetProcessesByName(ExcelProcessName);
        }

        /// <summary>
        /// Finalizes an instance of the ExcelApp class.
        /// </summary>
        ~ExcelApp()
        {
            this.Dispose(false);
        }
        #endregion


        #region Private methods for IDisposable
        /// <summary>
        /// Dispose method
        /// </summary>
        /// <param name="disposing">Disposing status</param>
        protected void Dispose(bool disposing)
        {
            if (this.disposed)
            {
                return;
            }

            if (disposing)
            {
                // Cleanup managed resource
                this.Close();
            }

            // Cleanup un-managed resource
            // ...
            this.CleanUnhandledAppInstance();

            this.disposed = true;
        }
        #endregion

        #region Private Excel methods - Application
        /// <summary>
        /// clean up unhandled Excel application instances.
        /// </summary>
        private void CleanUnhandledAppInstance()
        {
            Process[] currentExcelProcess = Process.GetProcessesByName(ExcelProcessName);
            if (currentExcelProcess == null || currentExcelProcess.Length == 0)
            {
                return;
            }

            List<Process> killList = null;
            if (this.originalExcelProcess == null || this.originalExcelProcess.Length == 0)
            {
                killList = new List<Process>(currentExcelProcess);
            }
            else
            {
                killList = new List<Process>();

                bool isExists;
                foreach (Process process in currentExcelProcess)
                {
                    isExists = false;
                    foreach (Process originalProcess in this.originalExcelProcess)
                    {
                        if (originalProcess.Id == process.Id)
                        {
                            isExists = true;
                            break;
                        }
                    }

                    if (!isExists)
                    {
                        killList.Add(process);
                    }
                }
            }

            if (killList != null || killList.Count > 0)
            {
                foreach (Process process in killList)
                {
                    process.Kill();
                }
            }
        }
        #endregion
    }

当考虑到某个操作可能会意外终止时：

        #region Public Excel methods - Workbook
        /// <summary>
        /// Creates the excel doc.
        /// </summary>
        /// <param name="fileName">the excel doc filename</param>
        public void CreateWorkbook(string fileName)
        {
            try
            {
                this.CurrentWorkbook = this.Application.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
                this.LatestWorksheet = this.CurrentWorkbook.Sheets[1] as Excel.Worksheet;
                this.CurrentWorksheet = this.LatestWorksheet;
                string fullPath = this.GetActualFullPath(fileName);

                this.LatestWorksheet.SaveAs(
                    fullPath,
                    this.currentFileFormat,
                    Type.Missing,
                    Type.Missing,
                    Type.Missing,
                    Type.Missing,
                    Excel.XlSaveAsAccessMode.xlExclusive,
                    Type.Missing /* 28591 */ /* ISO 8859-1 Latin 1; Western European (ISO) */,
                    Type.Missing,
                    Type.Missing);
            }
            catch (Exception ex)
            {
                this.Dispose();
                throw ex;
            }
        }
        #endregion