Workbook SourceBook1 = new Workbook();
SourceBook1.Open("c:\\excels\\ChartTest.xls");

Workbook SourceBook2 = new Workbook();
SourceBook2.Open("C:\\excels\\PictureTest.xls");

SourceBook1.Combine(SourceBook2);
SourceBook1.Save("c:\\excels\\combined.xls"); 

SourceBook1.Combine(SourceBook2);
SourceBook1.Save("c:\\excels\\combined.xls"); 

        private DataTable GetCustomersTable()
         {
             DataTable dt = new DataTable( "Customers");
             dt.Columns.Add( "Address");
             dt.Columns.Add( "City");
             dt.Columns.Add( "CompanyName");
             dt.Columns.Add( "ContactName");
             dt.Columns.Add( "ContactTitle");
             dt.Columns.Add( "Country");
             dt.Columns.Add( "CustomerID");
             dt.Columns.Add( "Fax");
             dt.Columns.Add( "Phone");
             dt.Columns.Add( "PostalCode");
             dt.Columns.Add( "Region");
             for (int i = 0; i  < 10; i++)
             {
                 DataRow row = dt.NewRow();
                 for (int j = 0; j  < dt.Columns.Count; j++)
                 {
     row[j] = dt.Columns[j].ColumnName +  "(" + i.ToString() + "," + j.ToString() + ")";
                 }
                 dt.Rows.Add(row);
             }
             return dt;
         }

         private void btnCombind_Click(object sender, EventArgs e)
         {
             Workbook SourceBook1 = new Workbook();

             string path = System.IO.Path.Combine(Application.StartupPath, 
"SmartMarkerCombind.xls");
             DataTable dt = GetCustomersTable();//使用DataTable對(duì)象

             List <string> fileList = new List<string>();
             for (int i = 0; i  < 3; i++)
             {
                 Workbook tempBook = new Workbook();

                 //創(chuàng)建設(shè)計(jì)模板對(duì)象，并綁定數(shù)據(jù)源
                 WorkbookDesigner designer = new WorkbookDesigner();
                 designer.Open(path);
                 designer.SetDataSource(dt);
                 designer.Process();

                 //修改Sheet的名稱
                 designer.Workbook.Worksheets[0].Name =  "test" + i.ToString();

                 //根據(jù)數(shù)據(jù)源和自定義模板，生成相應(yīng)的報(bào)表Excel文件
                 string fileToSave = System.IO.Path.Combine
(Application.StartupPath, string.Format( "Combind{0}.xls", i));
                 designer.Save(fileToSave, FileFormatType.Excel2003);
                 fileList.Add(fileToSave);

                 //第一次要打開
                 if (i == 0)
                 {
                     SourceBook1.Open(fileToSave);
                 }
                 else
                 {
                     //第二個(gè)使用Combind函數(shù)操作
                     tempBook.Open(fileToSave);
                     SourceBook1.Combine(tempBook);
                 }
             }

             //最后將WorkBook保存為一個(gè)文件即可
             string soucePath = 

System.IO.Path.Combine(Application.StartupPath,  "Combind.xls");
             SourceBook1.Save(soucePath);

             //刪除臨時(shí)文件
             foreach (string file in fileList)
             {
                 if (File.Exists(file))
                 {
                     File.Delete(file);
                 }
             }

             //打開文件
             Process.Start(soucePath);
         }
     }