分享Excel批量替换方法-C#

using Microsoft.Office.Interop.Excel;//下载，然后添加引用

       /// <summary>
        /// excel查找并替换
        /// </summary>
        /// <param name="filePath">excel路径</param>
        /// <param name="cellRegion">要查找的单元格，如A1:A10</param>
        /// <param name="oldWord">将被替换的字符串</param>
        /// <param name="newWord">替换成的字符串</param>
        public void ReplaceString(string filePath, string cellRegion,string []oldWord,string []newWord)
        {
            //开启EXCEL服务
            Microsoft.Office.Interop.Excel.Application excelApplication = new Microsoft.Office.Interop.Excel.Application();
            try
            {
                //定义一些需要用到的变量，打开工作簿
                object MissingValue = Type.Missing;
                Microsoft.Office.Inte