合并Excel文件

weixin_30740295

于 2012-11-30 15:18:00 发布

阅读量59

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/sshoub/archive/2012/11/30/2796277.html

合并Excel文件

//合并Excel文件
        private void MargeExcelFile(string destFile, string dirPath)
        {
            DirectoryInfo dir = new DirectoryInfo(dirPath);
            FileInfo[] files = dir.GetFiles("*.xlsx");

            Microsoft.Office.Interop.Excel.Application app = app = new Microsoft.Office.Interop.Excel.Application();
            Microsoft.Office.Interop.Excel._Workbook m_Workbook = null;
            try
            {
                Microsoft.Office.Interop.Excel._Workbook result = app.Workbooks.Add();
                foreach (var item in files)
                {
                    m_Workbook = app.Workbooks.Open(Path.GetFullPath(item.FullName));
                    foreach (Microsoft.Office.Interop.Excel._Worksheet each in m_Workbook.Sheets)
                    {
                        each.Copy(result.Worksheets[1]);
                    }
                }
                if (File.Exists(destFile) == true)
                {
                    File.Delete(destFile);
                }
                result.SaveAs(destFile);
            }
            catch
            {
            }
            finally
            {
                if (m_Workbook != null)
                {
                    m_Workbook.Close();
                }
                app.Quit();
            }
        }