c#(Asp.net)多个Excel文件合并到一个新的excel中

来源:互联网 发布:linux alien 编辑:程序博客网 时间:2024/05/01 12:33

 代码很简单,有需要的朋友可以直接把代码copy过去,改成自己的路径,就可以使用,我已经测试,没有问题!  

        Excel.Application app = new Excel.Application();
            Excel._Workbook result = app.Workbooks.Add();
            Excel._Workbook wb1 = app.Workbooks.Open(Path.GetFullPath("E:\\1407895431785.xls"));
            Excel._Workbook wb2 = app.Workbooks.Open(Path.GetFullPath("E:\\1407895459016.xls"));
            foreach (Excel._Worksheet each in wb1.Sheets)
            {
                each.Copy(result.Worksheets[1]);
            }
            foreach (Excel._Worksheet each in wb2.Sheets)
            {
                each.Copy(result.Worksheets[1]);
            }
            wb1.Close();
            wb2.Close();
            result.SaveAs("E:\\result.xlsx");
            app.Quit();

0 0