How to find the exact value from the range data table using LINQ C#

Please check the following code, I load the data in excel into a Datatable, then use linq to find the row where the parameter is located, and output the final value.

    static void Main(string[] args)  
    {  
        System.Data.DataTable dataTable = GetSheetDataAsDataTable(@"D:\test\excel\3.xlsx");  
        int result =  GetFinalValue(dataTable, 11);  
        Console.WriteLine(result);  
  
        Console.WriteLine("Press any key to continue...");  
        Console.ReadLine();  
    }  
  
    public static int GetFinalValue(System.Data.DataTable dataTable, int num)   
    {  
        var row1 = (from row in dataTable.AsEnumerable()  
                 where double.Parse(row["A"].ToString()) <= num && double.Parse(row["B"].ToString()) >= num  
                 select row).First();  
        return int.Parse(row1["FinalValue"].ToString());  
    }  
    public static System.Data.DataTable GetSheetDataAsDataTable(String filePath)  
    {  
        Application xlApp = new Excel.Application();  
        Workbook xlBook = xlApp.Workbooks.Open(filePath);  
        Worksheet xlSheet = (Worksheet)xlBook.Worksheets[1];  
        Range xlRange = xlSheet.UsedRange;  
        //Range xlRange = xlSheet.get_Range("A1", "C5");  
        System.Data.DataTable dt = new System.Data.DataTable();  
        try  
        {  
            DataRow row = null;  
            for (int i = 1; i <= xlRange.Rows.Count; i++)  
            {  
                if (i != 1)  
                    row = dt.NewRow();  
                for (int j = 1; j <= xlRange.Columns.Count; j++)  
                {  
                    if (i == 1)  
                        dt.Columns.Add(((Range)xlRange.Cells[1, j]).Value.ToString(),typeof(string));  
                    else  
                        row[j - 1] = ((Range)(xlRange.Cells[i, j])).Value;  
                }  
                if (row != null)  
                    dt.Rows.Add(row);  
            }  
        }  
        catch (Exception ex)  
        {  
            Console.WriteLine(ex.Message);  
        }  
        finally  
        {  
            xlBook.Close();  
            xlApp.Quit();  
        }  
        return dt;  
    }  

If there is more than one table in the excel file, you can use code like this to get the required range:

Range xlRange = xlSheet.get_Range("A1", "C5");  

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.