Hi,

Please use the below code read data from excel and show in grid view

OleDbConnection sqlCon;
try
{
 string strConn = @"provider=Microsoft.Jet.OLEDB.4.0; data source=" + Server.MapPath("~/Upload/EBREADING.xls") + ";Extended Properties=Excel 8.0;";
 sqlCon = new OleDbConnection(strConn);
 if (sqlCon.State == ConnectionState.Open)
 {
    sqlCon.Close();
 }
 }
 catch
 {
    sqlCon = new  OleDbConnection(@"provider=MMicrosoft.ACE.OLEDB.12.0; data source=" + Server.MapPath("~/Upload/EBREADING.xls") + ";Extended Properties=Excel 12.0;");
     if (sqlCon.State == ConnectionState.Open)
     {
       sqlCon.Close();
     }
 }
 OleDbDataAdapter dataAdapter = new OleDbDataAdapter("select * from  [sheet1$] ", sqlCon);

 DataSet ds = new DataSet();
 if (sqlCon.State == ConnectionState.Closed)
 sqlCon.Open();
 dataAdapter.Fill(ds);

 GridView11.DataSource=ds;
 GridView.DataBind()

Hope this will help you.