How to Read Excel File using ASP.NET

Today I am Sharing Excel Reader to read Excel file from Asp.net C#.

Today I am Sharing Excel Reader to read Excel file from Asp.net C#.

This is database in Excel:

This is Codes:

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

public partial class ExcelReader : System.Web.UI.Page
{
    OleDbConnection olcon = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Password="""";User ID=Admin;Data
Source=E:\exceldatareader\excelread\info.xlsx
;Mode=Share Deny Write;Extended Properties=""HDR=YES;"";Jet OLEDB:Engine Type=37");
    OleDbDataAdapter olda;

    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            olcon.Open();
            string query = "select [ID],[Name],[Business] from [Sheet1$]";
            olda = new OleDbDataAdapter(query, olcon);
            DataSet ds = new DataSet();
            olda.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
        catch (Exception ex)
        {
           Response.Write(ex.Message + ex.StackTrace); }
        finally
        { olcon.Close(); }
    }
}

This is Result: