使用Workbooks.Open读取excel文件时出错，SOS

[Jerzy]

。。。。。。
Excel.ApplicationClass app = new Excel.ApplicationClass();
Excel.WorkbookClass workBook = (Excel.WorkbookClass)app.Workbooks(Path,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value);

报如下错误：
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in excel2txt.exe

Additional information: Old format or invalid type library.

请问是怎么回事啊，编译没错的阿

[shino_wu]

OWC组件是不是太旧了哦，用11.0代替

[Jerzy]

我用的就是11.0的，奇怪了，急啊我

[Jerzy]

我也尝试了下面方式也报同样的错误：

Excel.Workbook workBook = app.Workbooks.Open(Path,
0,
true,
5,
"",
"",
true,
Excel.XlPlatform.xlWindows,
"\t",
false,
false,
0,
true,
1,
0);

[Jerzy]

SOS

[lwh_gsww]

试试这个方法：

public Boolean open(String fileName)
{
try
{
xlApp = new ApplicationClass();
//xlApp.Visible = true;
xlApp.Visible = false;
xlApp.DisplayAlerts = false;
xlWorkbook = xlApp.Workbooks.Open(fileName, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
xlWorksheet = (_Worksheet)xlWorkbook.Sheets[1];
return true;
}
catch (Exception ex)
{
return false;
}
}

[lwh_gsww]

加这个

_Application xlApp = null;
_Workbook xlWorkbook = null;
_Worksheet xlWorksheet = null;
System.Reflection.Missing oMissing = System.Reflection.Missing.Value;