如何通过OleDB读取Excell的合并
代码如下:String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sName + ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\"";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
string s = ds.Tables[0].Rows[10,2].ToString();
objConn.Close();
问题:因为8-12行的第二列是合并的。现在我要读10行第二列的数据,怎么读?