public DataTable ExportExcel(string sheetName) { DataTable rs = new DataTable();
if (!this.FileUpload1.HasFile) {
this.RunInSide("请选择要导入的文件！"); return null; } try { //获取服务器路径 string upPath = Request.PhysicalApplicationPath + "BasisManage\\ExportExcel\\ExcelFolder\\" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls"; FileUpload1.PostedFile.SaveAs(upPath); OleDbConnection conn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;" + "data source=" + upPath + ";" + "extended properties=\"excel 8.0;IMEX=1;\"");//很重要的（IMEX=1），缺少会导致部分数据读不出来 OleDbCommand myoledbcommand = new OleDbCommand("select * from [" + sheetName + "$]", conn); OleDbDataAdapter mydata = new OleDbDataAdapter(myoledbcommand); mydata.Fill(rs);
} catch (Exception ex) { this.RunInSide("格式不正确！请重新选择你要载入的文件！"); return null; } return rs; }
转载于:https://www.cnblogs.com/n666/archive/2009/10/23/2191058.html
相关资源：数据结构—成绩单生成器