C#操作Excel时,excel.没有 Worksheet属性,也没有WorkBook 属性...

Question

我的是: vs2005  +win 7 已添加COM: micrsoft office 12.0 object libarary.C#操作Excel时,excel.没有 Worksheet属性,也没有WorkBook 属性...只有excel.Worksheets  ;  excel.WorkBooks 等属性,为何?
我想取得excel 文件中的 sheet2 页,在网上找到了好多资料,,
     Microsoft.Office.Interop.Excel.Application excel=new  Microsoft.Office.Interop.Excel.ApplicationClass(); excel.Workbooks.Open(strFilePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing,Type.Missing );            excel.Visible = true;想取得当前的sheet ,没有办法实现?

Answer 1

Excel 12.0 Object Library
using Excel = Microsoft.Office.Interop.Excel; 
 
Excel.Application app = new Excel.ApplicationClass();   
Excel.Workbook workBook = app.Workbooks.Open(templetFile,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing);   
Excel.Worksheet workSheet = (Excel.Worksheet)workBook.Sheets.get_Item(1);   
for(int i=1;i <sheetCount;i++)   
{   
((Excel.Worksheet)workBook.Worksheets.get_Item(i)).Copy(missing,workBook.Worksheets[i]);   
 
}   

Answer 2

using Microsoft.Office.Interop.Excel;
using Microsoft.Office.Core;  引用了吗