Step 1: Create new widows form application.

Step 2: Create windows form with button, label, combobox and datagridview as below.

Step 3: Write following code.

  1. using System;
  3. using System.Data;
  4. using System.Data.OleDb;
  6. using System.Windows.Forms;
  8. namespace ExcelDemo
  10. {
  12. public partial class Form1: Form
  14. {
  16. OleDbConnection OleDbcon;
  18. public Form1()
  20. {
  22. InitializeComponent();
  24. }
  26. private void button1_Click(object sender, EventArgs e)
  28. {
  30. OpenFileDialog openFileDialog = new OpenFileDialog();
  32. openFileDialog.Filter = "Excel Files|*.xls;*.xlsx";
  34. openFileDialog.ShowDialog();
  36. if (!string.IsNullOrEmpty(openFileDialog.FileName))
  38. {
  40. OleDbcon = new OleDbConnection(@ "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + openFileDialog.FileName + ";Extended Properties=Excel 12.0;");
  42. OleDbcon.Open();
  44. DataTable dt = OleDbcon.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
  46. OleDbcon.Close();
  48. comboBox1.Items.Clear();
  50. for (int i = 0; i < dt.Rows.Count; i++)
  52. {
  54. String sheetName = dt.Rows[i]["TABLE_NAME"].ToString();
  56. sheetName = sheetName.Substring(0, sheetName.Length - 1);
  58. comboBox1.Items.Add(sheetName);
  60. }
  62. }
  64. }
  66. private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
  68. {
  70. OleDbDataAdapter oledbDa = new OleDbDataAdapter("Select * from [" + comboBox1.Text + "$]", OleDbcon);
  72. DataTable dt = new DataTable();
  74. oledbDa.Fill(dt);
  76. dataGridView1.DataSource = dt;
  78. }
  80. private void button2_Click(object sender, EventArgs e)
  82. {
  84. OpenFileDialog OpenFileDialog = new OpenFileDialog();
  86. OpenFileDialog.ShowDialog();
  88. string path = OpenFileDialog.FileName;
  90. }
  92. }
  94. }

Step 4: Run application. And click on browse button.

Step 5: From open file dialog select excel file. When file is selected, all sheet names in file are filled in combobox.

Step 6: Select any sheet name from combobox. Then data from that selected sheet is filled in datagridview. The first row of excel sheet is considered as column header.