/// <summary> /// 保存到服务器,读出Excel中原始数据数据 /// </summary> /// <returns></returns> private DataTable SaveToServer() { if (Request.Files.Count > 0 && Request.Files[0].FileName != "") { HttpPostedFile postedFile = Request.Files[0]; byte[] buffer = new byte[postedFile.ContentLength]; postedFile.InputStream.Read(buffer, 0, postedFile.ContentLength); postedFile.InputStream.Close(); string folderPath = Server.MapPath("~/Framework/SingleTable/upfiles/"); string savePath = folderPath + DateTime.Now.ToString("yyyy-MM-dd_HHmmss") + ".xls"; FileStream pFileStream = null; try { pFileStream = new FileStream(savePath, FileMode.OpenOrCreate); pFileStream.Write(buffer, 0, buffer.Length); } catch { } finally { if (pFileStream != null) { pFileStream.Close(); } } MSExcel msE = new MSExcel(); DataTable dt = msE.ExcelToDataTable(savePath); return(dt); } else { return(null); } }