Giving the cell value, find the row, column.

I have a spreadsheet with 10 columns, I want for example to inform the cell value and the column and get back the value contained in the cell that is in the same row found but in a different column.

In the picture for example I want to give the cell value "b" and the column A then search the line where "b" was found and get back the value from the same line but in a different column, in the example Column H, value "PPP".

Free Spire.XLS library provides the ability to search cell value and return the row or column where the cell is located.

https://www.nuget.org/packages/FreeSpire.XLS/

Refer the below code example:

using Spire.Xls;
using System;
namespace SearchString
{
class Program
{
static void Main(string[] args)
{
//Load Excel file
Workbook workbook = new Workbook();
workbook.LoadFromFile("Input.xlsx");
//Get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Search the value "b" in the worksheet
CellRange range = sheet.FindString("b", false, false);
//Get the row where the seached value is located
CellRange row = range.EntireRow;
//Get the value of the eighth cell in the row
string value = row.CellList[7].Value;
Console.WriteLine(value);
Console.ReadKey();
}
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

alice yang6y ago
Accepted answer
Free Spire.XLS library provides the ability to search cell value and return the row or column where the cell is located.
https://www.nuget.org/packages/FreeSpire.XLS/

Refer the below code example:
using Spire.Xls;
using System;

namespace SearchString
{
    class Program
    {
        static void Main(string[] args)
        {
            //Load Excel file
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("Input.xlsx");

            //Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            //Search the value "b" in the worksheet
            CellRange range = sheet.FindString("b", false, false);

            //Get the row where the seached value is located
            CellRange row = range.EntireRow;

            //Get the value of the eighth cell in the row
            string value = row.CellList[7].Value;

            Console.WriteLine(value);
            Console.ReadKey();
        }
    }
}
0
Luiz Boas6y ago
Thank you very much! It helps a lot.
0