如何查找与当前单元格相邻的单元格值C#+Excel

Question

我已经编写了一个程序，找到一个包含“customer：”的单元格，并且程序成功地工作。问题是，我想要直接挨着单元格的单元格的值。布局如下所示：

__________   _________
|Customer:| | Steve  |
|_________| |________|
|Customer:| | John   |
|_________| |________|
|Customer:| | Frank  |
|_________| |________|

public void gatherInfo()
    {
        string temp = "";

        Excel.Range currentFind = null;
        Excel.Range firstFind = null;

foreach (Excel.Worksheet sheet in excelWorkbook.Application.Worksheets)
        {
            try
            {
                // access cell within sheet
                Excel.Range excelCell =
                      (Excel.Range)sheet.get_Range("A1", Type.Missing);                   

                currentFind = excelCell.Find("Customer:", Type.Missing,
            Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart,
            Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, false,
            Type.Missing, Type.Missing);

                while (currentFind != null)
                {
                    // Keep track of the first range you find. 
                    if (firstFind == null)
                    {
                        firstFind = currentFind;
                    }

                    // If you didn't move to a new range, you are done.
                    else if (currentFind.get_Address(Excel.XlReferenceStyle.xlA1)
                          == firstFind.get_Address(Excel.XlReferenceStyle.xlA1))
                    {
                        //String value of cell
                        temp = currentFind.Value2.ToString();

                        break;
                    }

                    currentFind = excelCell.FindNext(currentFind);

                }

                //Find adjacent cell value here?

                holdInformation.Add(temp);

            }

            catch
            {
                Console.WriteLine("Couldn't get customer name");
            }

Answer 1

我想偏移功能就是你要找的。在您的代码中，可以添加一行内容：

firstFind.Offset[0, 1]; 

“0”表示以当前行为目标“1”表示要以excel范围右侧第1列为目标