110,825
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
//参考,一下是将aaa.xls里面的sheet添加到bbb.xls里面去
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
xlApp.Visible = true;
Microsoft.Office.Interop.Excel.Workbook xlBook;
object m_objOpt = System.Reflection.Missing.Value;
xlBook = xlApp.Workbooks.Open(@"c:\aaa.xls", m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
Microsoft.Office.Interop.Excel.Worksheet xlSheet;
Microsoft.Office.Interop.Excel.Workbook xlBook2;
xlBook2 = xlApp.Workbooks.Open(@"c:\bbb.xls", m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
for (int i = 1; i <= xlBook.Worksheets.Count; i++)
{
xlSheet = xlBook.Worksheets[i] as Microsoft.Office.Interop.Excel.Worksheet;
xlSheet.Copy(m_objOpt, xlBook2.Worksheets[3]);
}