ho we read excel file data into gridview

<script runat="server">
    void Page_Load(Object sender, EventArgs e)
    {
        DataSet authorsDataSet;
        string filePath = Server.MapPath("Authors.xml");
        authorsDataSet = new DataSet();
        //Read the contents of the XML file into the DataSet
        authorsDataSet.ReadXml(filePath);
        authorsGird.DataSource = authorsDataSet.Tables[0].DefaultView;
        authorsGird.DataBind();
    }

</script>

Use this where required and give the path of xml file.

hi, There are numerous link available which will give answer to your question.
Have look at this link of codeproject.

How to import excel file to grid view in asp.net using c# AND save grid view to database sql server 2005[^] Have a look at the solution3.

This will definitely meet your expectation.