Excel reading Based on the key value

Question

Hello All I am the Beginner in C#. i want to read Excel file. in Excel file read based on the key Vale(key value means one column). Please Help me. Thanks in Advance..

Laxmikant · Answer

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

Candy Brown · Answer

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 .

Vasu Gadhiya · Answer

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$] -------------------------------------