Excel reading Based on the key value

Read all data from excel to DataTable  and then filter it

see below article which will help you to get excelsheet data in datatable using OleDBConnection

http://dotnetmentors.com/aspnet/display-excel-data-in-web-page.aspx

Hareesh here is a bit more friendlier way that you can use to read Excel file's cell values in .NET:

// Load excel file.
ExcelFile file = ExcelFile.Load(@"C:\Sample.xlsx");

// Get first worksheet.
ExcelWorksheet firstSheet = file.Worksheets[0];
 
// Various ways of reading 'B3' cell's value.
Console.WriteLine(firstSheet.Cells["B3"].Value);
 
Console.WriteLine(firstSheet.Rows["3"].Cells["B"].Value);
Console.WriteLine(firstSheet.Rows[2].Cells[1].Value);
 
Console.WriteLine(firstSheet.Columns["B"].Cells["3"].Value);
Console.WriteLine(firstSheet.Columns[1].Cells[2].Value);

The code comes from this .NET component that can process excel files.

OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Stock.xlsx;Extended Properties=Excel 8.0");

try
{

con.Open();

string query = "select * from [Sheet1$]";

OleDbDataAdapter mycommand = new OleDbDataAdapter(query, con);

DataSet ds = new DataSet();

mycommand.Fill(ds, "Table");

dataGridView1.DataSource = ds.Tables[0];

}
catch (Exception ex)
{

MessageBox.Show(ex.Source);

}
finally
{

con.Close();

}


-------------------------------------

to read by column change query list column name select statement.

like
Select id, name from [Sheet1$]


-------------------------------------