读取excel用前端还是后端好_web前端选择Excel文件后端读取保存数据库

//前端

&ltlabel class="btn blue" title="批量导入" for="fileToUpload"&gt导入&lt/label&gt&ltbr /&gt

@using (Html.BeginForm("UploadTrainee", "Trainee", FormMethod.Post, new { enctype = "multipart/form-data", id = "uploadFile" }))

{

&ltinput type="file" name="fileToUpload" id="fileToUpload" οnchange="fileSelected();" style="display:none; " /&gt

}

//js

function fileSelected() {

var file = $("#fileToUpload").prop("files")[0];

if (file) {

var fileType = file.type;

if (fileType != 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' && fileType != "application/vnd.ms-excel")

{

showError({ message: "请选择Excel格式文件!", autoHide: true, duration: 1000 });

return;

}

$("#uploadFile").submit();

}

}

//C#服务器

[HttpPost]

public ActionResult UploadTrainee()

{

HttpPostedFileBase file = Request.Files["fileToUpload"];

string fileName = Path.GetFileName(file.FileName);

string savePath = AppDomain.CurrentDomain.BaseDirectory + @"Content\TemplateFile";

if (file != null && file.ContentLength &gt 0)

{

if (!Directory.Exists(savePath))

{

Directory.CreateDirectory(savePath);

}

var str = fileName.Split('.');

var tempFileName = string.Format("{0}_{1}.{2}", str[0], DateTime.Now.ToFileTimeUtc().ToString(), str[1]);

savePath = Path.Combine(savePath, tempFileName);

try

{

file.SaveAs(savePath);

var dt = new DataTable();

var excelHelper = new ExcelHelper(savePath);

excelHelper.ExcelToDataTable(out dt);//读取Excel文件为DataTable

if (dt == null || dt.Rows.Count &lt 1)

{

ViewBag.Message = "上传文件失败！";

}

else

{

#region 保存学员

var index = dt.Rows.Count;

foreach (DataRow dr in dt.Rows)

{

index--;

if (index == 0) break;

}

#endregion

}

System.IO.File.Delete(savePath);//保存完毕后删除临时文件

}

catch(Exception ex)

{

ViewBag.Message = "上传文件失败！";

System.IO.File.Delete(savePath);//保存完毕后删除临时文件

}

}

else

{

ViewBag.Message = "上传的文件是空文件！";

}

return Redirect("/Teacher/Trainee/Index");

}