/// <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);
}
}
