//导入命名空间
using System.Data.OleDb;
//ADO.NET读取数据
String XslPath = Server.MapPath(Request.QueryString["name"].ToString()); // 绝对物理路径
String ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=/"Excel 8.0;/";data source=" + XslPath;
String Sqls = "SELECT * FROM [Sheet1$]";
OleDbDataAdapter da = new OleDbDataAdapter(Sqls, ConnStr);
Dadaset ds = new Dataset();
da.Fill(ds); //将Excel数据填充到DATASET
文章出处:http://www.diybl.com/course/4_webprogram/asp.net/netjs/200863/121212.html