Importing data from excel to gridview

This code snippet describes about how we can import the data from an excel sheet into gridview. Please import the following namespaces.

using System.Data.OleDb;
using System.Data;

 // Connect to the Excel Spreadsheet
           OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("ExcelImport.xls") + ";" + "Extended Properties=Excel 8.0;");
          // create your excel connection object using the connection string
          con.Open();
         // Create a new Adapter
         OleDbDataAdapter objDataAdapter = new OleDbDataAdapter();
        //Below "Members" is the worksheet name of the excel document which is appended with $ symbol
        OleDbCommand objSelectCommand = new OleDbCommand("SELECT * FROM [Members$]", con);
        objDataAdapter.SelectCommand = objSelectCommand;

      // Create a DataSet
      DataSet ds = new DataSet();
  
    // Populate the DataSet with the spreadsheet worksheet data
     objDataAdapter.Fill(ds);

  // Bind the data to the GridView
   GridViewExcel.DataSource=ds.Tables[0].DefaultView;
   GridViewExcel.DataBind();