aspx:
<form id="form1" runat="server">
<div>
<input id="File1" type="file" name="File1" runat=server /><br />
<br />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /><br />
<br />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
using System.Data.OleDb;
protected void Button1_Click(object sender, EventArgs e)
{
string source = File1.Value;
string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +source+";Extended Properties=Excel 8.0";
string query = "select * from [Sheet1$]";
OleDbCommand cmd = new OleDbCommand(query, new OleDbConnection(ConnStr));
OleDbDataAdapter adp= new OleDbDataAdapter(cmd);
DataSet ds= new DataSet();
adp.Fill(ds,"[Sheet1$]");
GridView1.DataSource = ds;
GridView1.DataMember = "[Sheet1$]";
GridView1.DataBind();
}