{
string str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("成績.xls") + ";Extended Properties=Excel 8.0" ;
OleDbConnection con = new OleDbConnection(str);
con.Open();
OleDbDataAdapter ada = new OleDbDataAdapter("select * from [sheet1$]", con);
DataTable dt = new DataTable();
ada.Fill(dt);
GridView1.DataSource=dt;
GridView1.DataBind();
}
把EXCEL當成數據庫看待,註意下連接字符串和SQL語句就行了