110,535
社区成员
发帖
与我相关
我的任务
分享
DataSet dataSet = new DataSet();
DataTable table = new DataTable();
string str = HttpContext.Current.Server.MapPath("~/FileUpload/" + filename);
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + str +
";Extended Properties=\"Excel 8.0;IMEX=1;\"";
new OleDbConnection(connectionString).Open();
new OleDbDataAdapter(string.Format("select * from [{0}$]", "Sheet1"), connectionString).Fill(dataSet,
"dsImportOrders");
table = dataSet.Tables[0];
大概就这个意思,凑合看吧