关于Excel对象的问题

Question

Excel.Workbook workbook=excel.Workbooks.Open(FileName,Missing.Value,false,Missing.Value,null,null,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);上面要有这一句
using System.Reflection;

Answer 1

下面的代码我用过的没有问题.
string FileName=null;
OpenFileDialog dlg=new OpenFileDialog();
dlg.Filter="Excel文件(*.xls)|*.xls";
if(dlg.ShowDialog()==DialogResult.OK)
FileName=dlg.FileName;
else
return;
Excel.ApplicationClass excel=new Excel.ApplicationClass();
Excel.Workbook workbook=excel.Workbooks.Open(FileName,Missing.Value,false,Missing.Value,null,null,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
Excel.Sheets sheets=workbook.Sheets;
Excel.Worksheet worksheet=(Excel.Worksheet)sheets.get_Item(1);
Excel.Range range;
excel.Visible=true;