根据坐标返回Excel单元格的值

Question

首先搜索 B2 所在的列，得到所在列，要求返回B2所在列第5行值。（C列中合并了单元格）

Answer 1

sheet.get_Range("B1",Missing.value).Value2;
Excel.Range ran=(Excel.Range)mSheet.Cells[i,j];   
if(ran.Value2==null)
{}
或
using (OleDbConnection Connection = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source="
 + @"D:\Data.xls"
   + ";Extended Properties=Excel 8.0"))
            {
                OleDbDataAdapter DataAdapter = new OleDbDataAdapter("Select * from [Sheet1$]", Connection);
                DataTable DT = new DataTable();
                DataAdapter.Fill(DT);
            }

Answer 2

sheet.get_Range("B1",Missing.value).Value2;
Excel.Range ran=(Excel.Range)mSheet.Cells[i,j];   
if(ran.Value2==null)
{}能否给每个行一个注释？

Answer 3

http://hi.baidu.com/zhaochenbo/blog/item/f6d70ff7bf32fa2a730eec39.html

Answer 4

搜索 1 所在的行i1  B2所在的列 j1  返回[i1,j1]值  即上图中第5行第3列值 
有谁能帮忙吗

Answer 5

给你一个例子看看：
public void OpenExcel()
        {
            Application app = new Application();//Open Excel Application.
            Workbooks wbs = app.Workbooks;
            _Workbook wb = wbs.Add(@"D:\work\30yr_pmmsmnth.xls");//Open an existing workbook
            Sheets shs = wb.Sheets;
            _Worksheet wsh = (_Worksheet)shs.get_Item(1);//Select the first Sheet page            int a = 8;
            int b = 20;
            for (int i = 0; i < 6; i++)
            {
                if (i == 0)
                {
                    for (; a < b; a++)
                    {
                        Range rr = wsh.get_Range("A" + a, "U" + a);
                        Object[,] saRet = (System.Object[,])rr.get_Value(System.Reflection.Missing.Value);
                        for (int n = 0; n < 7; n++)
                        {
                            string indexs = "";
                            if (n == 0)
                            {
                                indexs = "B5";
                            }
                            else if (n == 1)
                            {
                                indexs = "E5";
                            }
                            else if (n == 2)
                            {
                                indexs = "H5";
                            }
                            else if (n == 3)
                            {
                                indexs = "K5";
                            }
                            else if (n == 4)
                            {
                                indexs = "N5";
                            }
                            else if (n == 5)
                            {
                                indexs = "Q5";
                            }
                            else if (n == 6)
                            {
                                indexs = "T5";
                            }
                            Range range0 = wsh.get_Range(indexs, System.Reflection.Missing.Value);
                            Pmmsmnthyr pp = new Pmmsmnthyr();
                            pp.WeekDay = saRet[1, 1].ToString() + "/" + range0.Value2.ToString();
                            pp.Rate = saRet[1, 2 + n * 3].ToString();
                            pp.Pts = saRet[1, 3 + n * 3].ToString();
                        }
                    }
                }
}

Answer 6

搜索 1 所在的行i1，B2所在的列 j1，返回坐标[i1,j1]值 即上图中第5行第3列值  期待好的解决方法？