How to get single value from excel sheet using c#

Try to use Interop.Excel
add a reference to it.

using XLS = Microsoft.Office.Interop.Excel; 



            XLS.Application myapp=new XLS.ApplicationClass();

            XLS.Workbook wb = myapp.Workbooks.Open(@"d:\Mapping.xls");

            XLS.Worksheet sheet = (XLS.Worksheet)wb.Worksheets.get_Item(1);



            var cell = (XLS.Range)sheet.Cells[3,5];

            Console.Write(cell.Value2);

Seenuvasan, if this helps please login to Mark As Answer. | Alert Moderator

You can name the Cell as "ABC" and retrieve value using below code
string ConnectionString = string.Format("Data Source='{0}';Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0;HDR=YES;'", path);
using (DbCommand command = connection.CreateCommand())
{
command.CommandText = @"SELECT * FROM " + "ABC";
connection.Open();
}

Seenuvasan, if this helps please login to Mark As Answer. | Alert Moderator