1        String ExcelConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
2            "Data Source=" + Server.MapPath("ExcelFileName.xls") + ";" +
3            "Extended Properties=Excel 8.0;";
4
5        OleDbConnection ExcelConn = new OleDbConnection(ExcelConnString);
6
7        ExcelConn.Open();
8
9        OleDbCommand mySelectCommand = new OleDbCommand("SELECT * FROM [SheetName$]", ExcelConn);
10
11        OleDbDataAdapter myExcelAdapter = new OleDbDataAdapter();
12
13        myExcelAdapter.SelectCommand = mySelectCommand;
14
15
16        DataSet myDataSet = new DataSet();
17
18        myExcelAdapter.Fill(myDataSet, "ExcelInfo");
19        gvSearch.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView;
20        gvSearch.DataBind();
21
22        ExcelConn.Close();