con = new System.Data.OleDb.OleDbConnection(@"provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book2.xls;Extended Properties=Excel 8.0;");
con.Open();
adap = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]",con);
ds = new DataSet();
adap.Fill(ds);
dg1.DataSource = ds;
dg1.DataBind();