C# 查询Excel 查不出数据

[lxl_sports]

oleDbConnExcel = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 5.0;Data Source=" + filename + "");
                oleDbConnExcel.Open();
strGetDataFromExcel = "SELECT * FROM [" + sheetname + "]";
ds = new DataSet();
                        dar = new OleDbDataAdapter(strGetDataFromExcel, oleDbConnExcel);
                        dar.Fill(ds);

我读取了一个Excel 文件，里面有很多的sheet文件，大部分都能读取数据，但是其中有一个 只能读到 其中的部分数据，而很多的数字读取不到，请高手指点问题出在哪里？？？
补充：这个里面有合并单元格的，但是其他sheet文件也有，没有这个多。。。所以请高手指点。。。。

[zzxap]

insert into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Temp.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...table1 (A1,A2,A3) values (1,2,3)


INSERT INTO
OPENDATASOURCE('Microsoft.JET.OLEDB.4.0',
'Extended Properties=Excel 8.0;Data source=C:\training\inventur.xls')...[Filiale1$]
(bestand, produkt) VALUES (20, 'Test')

[zzxap]

合并单元格不行

[itcrazyman]

mark 帮顶

[takeshe]

学习

[gongsun]

up

[stonehy520]

Microsoft.Office.Interop.Excel.ApplicationClass MyExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();
MyExcel.Workbooks.Open(filename.Trim(), 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);
Microsoft.Office.Interop.Excel.Worksheet MyWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)MyExcel.Worksheets[sheetName];
Microsoft.Office.Interop.Excel.Range MyRange = MyWorkSheet.get_Range("A1", "H" + iSeleteArea.ToString());
object[,] MyHeader = (object[,])MyRange.Value2;
for (int i = 2; i < 60000; i++)
{

}