Moving to the next cell in Excel after searching using C#

Question

Eg. Searching for value "A" which is in A1. And moving to the next cell B1 and displaying it.

How would I go about doing that? Thanks!

Answer 1

Search for Text in Worksheet Ranges

Reading Excel From C#

Retrieving Excel 2007 Cell Values

Answer 2

private void CallCellReader(ArrayList myArray, int Count, int noRec)
{
    try
    {
        char c = 'A';
        for (int l = 1; l <= Count; l++)
        {
            int k = 2;
            for (int i = 1; i <= noRec; i++)
            {
                m_objRange = m_objSheet.get_Range(c.ToString() + k.ToString(), c.ToString() + k.ToString());
                myArray.Add(m_objRange.Cells.Value2.ToString());
                k++;
            }
            c++;
        }
    }
    catch (Exception exc)
    {
        Log.Add("Error in Reading Excel file " +exc);
        LogFlag = 1;
    }
}